Login Page - Create Account

Support Board


Date/Time: Sun, 08 Sep 2024 00:16:54 +0000



[Programming Help] - same csv file will produce different charts when imported as an scid file or open directly

View Count: 83

[2024-06-25 16:03:00]
d9e5c763 - Posts: 103
the content of the csv file is as follows:

Date,Time,Open,High,Low,Close,Volume,Number of Trades,Bid Volume,Ask Volume,Trade ID
20230425,10:00:00.003214,0,0,0,5.2,4.29,1,4.29,0,5522766811
20230425,10:00:00.003543,0,0,0,8.82352,6.5,1,6.5,0,5522766812

regarding the charts obtained, I provided screenshots
directly opening the csv file resulted in issues even after removing the "Trade ID" row, the csv file still did not display correctly
standardizing the volume by multiplying it by a certain number to convert it into an integer also yielded the same result

the data provided by this exchange is very messy, I only need to view it without trading, so didn't use the dtc protocol
after converting to scid, I lose the "Trade ID," which is the only data I can use to verify accuracy

this also brings up an question with the scid file
when the "Open" is 0.0, the Ask/Bid Volume already has enough information to indicate whether the trade direction is sell or buy
so does sierrachart read the "Close" value directly and ignore any content in "High" and "Low"?
if so, it seems I can write the "Trade ID" in these two fields.
Date Time Of Last Edit: 2024-06-25 16:39:14
imagescreenshot-20240625-235557.jpg / V - Attached On 2024-06-25 15:58:39 UTC - Size: 218 KB - 22 views
imagescreenshot-20240625-235529.jpg / V - Attached On 2024-06-25 15:58:43 UTC - Size: 147.89 KB - 21 views

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

Login

Login Page - Create Account