Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Retrieving Data into Spreadseets Via Sierra Charts
I want to be able to download data from Sierra Charts via a spreadsheet for analytical purposes. Say that I want to download IB high and IB Low from an indicator I have on my chart for last 100 days or so.. I cannot figure out how to get it to my excel sheet.
If you use the Spreadsheet Study study, you can set 'Use Excel' to Yes and the data will be outputted directly to Excel. This option is available but not recommended by Sierra.
You could also Copy/Paste from a spreadsheet study's spreadsheet to Excel.
Both of these options have number of rows limitations:
-max number of rows that can be copied.
-max setting of Number Of Rows might not cover 100 days on an intraday chart.
There is a cumbersome workaround for copying a large number of rows:
-Scroll the chart into the past, start a Chart Replay, then press Pause. This will align the right-most price bar to row 3 and allow you to see further into the past with rows below.
If you are not using VB, or graphs, you probably don't need to use Excel. The calculation could be done directly on the spreadsheet study's spreadsheet, or on a standalone spreadsheet. If you are using the Old Spreadsheets version, you can reference between spreadsheet study spreadsheets and standalone spreadsheets.
The integer is the number of days since 1/1/1900, and the decimal is the percentage of the day since midnight.
If you format the cell for Date, it will visually convert it for you.