Support Board

Date/Time: Mon, 20 May 2024 03:33:18 +0000

Post From: save spreadsheed data to scid ?

[2014-03-07 22:35:38] Link To Thread - Link To Post [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