NexusFi: Find Your Edge


Home Menu

 





Retrieving Data into Spreadseets Via Sierra Charts


Discussion in Sierra Chart

Updated
    1. trending_up 1,746 views
    2. thumb_up 7 thanks given
    3. group 2 followers
    1. forum 4 posts
    2. attach_file 0 attachments




 
Search this Thread

Retrieving Data into Spreadseets Via Sierra Charts

  #1 (permalink)
 
Traderwolf's Avatar
 Traderwolf 
Raleigh,NC
 
Experience: None
Platform: Versatile and Stable
Broker: Reliable and Accurate
Trading: Money
Posts: 250 since Feb 2012
Thanks Given: 154
Thanks Received: 1,028

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.

Can anyone help?

Thanks,

Wolf

Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
NexusFi Journal Challenge - April 2024
Feedback and Announcements
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Better Renko Gaps
The Elite Circle
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
GFIs1 1 DAX trade per day journal
18 thanks
The Program
18 thanks
  #2 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 216
Thanks Received: 603

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.

Reply With Quote
Thanked by:
  #3 (permalink)
 
Traderwolf's Avatar
 Traderwolf 
Raleigh,NC
 
Experience: None
Platform: Versatile and Stable
Broker: Reliable and Accurate
Trading: Money
Posts: 250 since Feb 2012
Thanks Given: 154
Thanks Received: 1,028



tomgilb View Post
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.

Thanks.. I see date and time is posted in some syntax I cannot recognize like 41950.6045. How do I decipher that?

THanks

Started this thread Reply With Quote
  #4 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 216
Thanks Received: 603


Traderwolf View Post
Thanks.. I see date and time is posted in some syntax I cannot recognize like 41950.6045. How do I decipher that?

THanks

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.

Reply With Quote
Thanked by:
  #5 (permalink)
 
WilleeMac's Avatar
 WilleeMac 
Prospect, KY. USA
 
Experience: None
Platform: Sierra Chart
Broker: Infinity
Trading: /CL
Posts: 687 since Jan 2012
Thanks Given: 309
Thanks Received: 617

I don't know if this topic is still active or has been answered

However, if you want to download data (for me /CL, /6E) you can use the "Write Bar Data To File" study

It will create a text file with comma separated values in the Data Folder ie CLH5-BarData.txt

Keep in mind it downloads data exact same as chart settings and date range ie M5 last 20 days

I just finished downloading /CL 6-15-2014 through 2-6-14 for Globex to New York

In this case it is 1800 to 07:59:59 and 0800 to 16:59:59

I'm comparing Globex OHLC to New York OHLC

After you've done this either make hidden the study or remove and add it each time you need it (I think because it's a "study.")

-Bill

Follow me on Twitter Reply With Quote
Thanked by:




Last Updated on February 9, 2015


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts