You can streaming real-time contracts data link into your excel.
To link data to excel:
- From the Settings menu, click System Options. The Settings dialog box appears.
- In the Misc tab, specify name of the spreadsheet in Worksheet Name box (suggested default is Sheet1).
- Click Connect button to start receiving all the contacts data.
- Check Auto-Connect on Start to start receiving contracts data every time you open the console.
Real-Time contract daft will be displayed in Excel will include: Contract Name, Ask, Ask Vol, Bid, Bid Vol, Last Price, Vol, Exchange Time, Low, High, Open, Prev Close, Change, Orders, Pos, Avg, Points, Open P&L, Cum P&L, Total P&L.