Requirements
- Excel 365 - the AddIn makes use of some excel features that are currently only available in Excel 365
- Sierra Chart with 2250 or higher
Not sure which Excel version you have? See here (TBD, add link)
Quick Start
- Start Sierra Chart
- In Sierra Chart, enable DTC Protocol Server with the default port (11099)
- Download the Excel AddIn to your computer
- Double click the AddIn file - this will fire up Excel and a dialog will appear asking to enable the AddIn for the current session
- Open a blank worksheet
- Enter a formula, for example: =sc.dtc.Last("EURUSD")
...
| Widget Connector | ||
|---|---|---|
|
AddIn Download and Installation
The Excel AddIn comes as an XLL file. You will need one of these depending if you have Excel 32 or 64 bit
...
Excel User Functions
Market Data
sc.dtc.MarketData.All(symbol)
Last Trade / Time And Sales
sc.dtc.LastTrade(symbol, include_symbol)
...
- Displays last x records in a table format
- Columns include DateTime, Price, Volume, BidOrAsk
Bid/Ask Quotes (L1)
sc.dtc.BidAsk(symbol, include_symbol) – DateTime, BidPrice, BidQty, AskPrice, AskQty
...
sc.dtc.BidAsk.AskPrice(symbol)
Market Depth (L2)
sc.dtc.MarketDepth(symbol, levels, plot_mode) - Plot mode has two options, “vertical” or “side-by-side”
Troubleshooting
Adding sc.Debug() to your sheet
sc.Debug()
Connection issues
