SierraChart-Excel
Product Details
Overview
- Easily combine Excel with your Sierra Chart data to create your custom dashboards, calculations, graphs, etc.
- Stream L1 (Bid/Ask), L2 (Market Depth), Time and Sales, Last Trade with lookback window settings
- Supports bar based OHLC, Volume and any subgraph data
- Stream real time data with no charts open
- Scalable, simple and efficient, no intermediate bridge software to run
The solution comes as two AddIns
- SC-Excel Dtc AddIn - real time data updates, DTC based
- SC-Excel Cht AddIn - real time + historical, data is based on a chart
When installed to Excel, these two AddIns extend Excel with new user functions. These functions provide the ability to access Sierra Chart data directly in Excel.
SC Excel DTC AddIn
The DTC AddIn supports real time streaming from SC to Excel. The AddIn utilizes the DTC protocol and requires that SC be setup as a DTC server.
Supports various Excel user functions for streaming data such as “Time and Sales”, “Market Depth” (also known as Order Book, Level 2), “Level 1” quotes, etc.
The AddIn does not require any charts open in Sierra Chart.
It does not provide access to any bar based data like OHLC, study subgraphs, volume, etc.
For more details on the DTC AddIn, see here: SC Excel Dtc AddIn
SC Excel Cht AddIn
Use this AddIn to access data that is chart based. Some examples include OHLC, subgraphs and volume. This AddIn requires a chart to be open with the relevant bar periods and studies applied. In general, any subgraph can be exported to exported to Excel.
For more detail, see here: SierraChart-Excel Cht AddIn
Requirements
- Sierra Chart version 2308 or higher
- Excel 365
Docs
Support
Display prices in:USD