Home >> Support Board

Support Board

Date/Time: Wed, 08 May 2024 23:52:38 +0000

How to Post a Message for Support

[User Discussion] - save spreadsheed data to scid ?

View Count: 1561

[2014-02-13 11:08:20] #1 [Go To First Post]
yoytu - Posts: 59
is there any way to export the a spreadsheet cell value to .scid file ? if there can be a stream maybe save the data every 1 min

[2014-02-13 17:53:04] #2 [Go To First Post]
vegasfoster - Posts: 444
Can I ask what are you trying to accomplish?

[2014-02-14 10:11:31] #3 [Go To First Post]
yoytu - Posts: 59
Can I ask what are you trying to accomplish? i am running some custom things on the price and i want to save the data so i can open that in a chart and have a visual representation

[2014-03-07 15:33:15] #4 [Go To First Post]
yoytu - Posts: 59
so anyone knows a way ? excel have some macro for this is there any way to export the data to a csv from sierrachart spreadsheet ?

[2014-03-07 22:35:38] #5 [Go To First Post]
vegasfoster - Posts: 444
SCID files have the following fields available. Date, Time, Open, High, Low, Last, Volume, Number of Trades, Bid Volume, Ask Volume. If you want to see the data visually then you will need to replace the OHLCVTBA data with your data. Disconnect from your data feed and Edit>>Export Intraday Data to Text File. Open the txt file with excel, modify the data as desired, then resave as a csv file with a different name. Then you can import the data using Edit>>Import and Load Intraday Data. I did this quickly using an M6E-201403-CME data file that I resaved as M6E, but after I imported I could not see anything, so I added a Moving Average-Simple using LAST as the input data with a period of 1 and then I could see the data. I used LAST because that was the data I replaced, and I deleted everything else. See attached pic. I am sure that a competent programmer could quickly create a custom study to automatically do this for you. Unfortunately I am far less than a competent programmer and this is beyond my skills. You may need to pay someone. To export to csv file, copy and paste the data from spreadsheet to excel and save as csv file. Again, a custom study could do this automatically as well. Date Time Of Last Edit: 2014-03-07 22:36:43


DataImport.png / V - Attached On 2014-03-07 22:34:56 UTC - Size: 22.78 KB - 391 views

To post a message in this thread, you need to log in with your Sierra Chart account: