Export of price data to CSV results in zeros for price data

I wanted to confirm that the data in SQ matches my Broker Data. SQ is loaded with M1 bars and Tick data from TDS csv files. I wanted to use SQ to convert the Tick or M1 data into H1 and export it so that I could perform an offline comparison to H1 data from my MT4 broker.

1. Open the "Data Manager" and select a currency such as EURUSD_Tick.
2. Select the "Export" tab then "Export to CSV"
3. In the "Select Timeframe and Session" area select "H1"  and leave the "Session" to NoSession  --  What are sessions?
4. Leave the rest of the fields as they are and press the "Export" button.

Open the CSV file in Excel and you will see that the only data that is exported is DateTime and Volume. The bid and Ask fields are all set to 0.



Attachments
  • Votes 0
  • Project StrategyQuant X
  • Type Bug
  • Status Fixed
  • Priority Normal

History

d
#1

Dave

18.06.2020 04:14

Task created

TT
#2

Tamas

18.06.2020 13:39

Status changed from New to Fixed

Attachment image-1.png added

image-1.png
(53.39 KiB)
You also need to change the output file format to Bar type. Then it will work.


Sessions are explained quite well here https://strategyquant.com/forum/topic/data-manager-new-fields/


If you still have a problem with export, please create a printscreen of your Export dialog + attach a file with the imported data


Votes: 0

Drop files to upload

or

choose files

Max size: 5MB

Not allowed: exe, msi, application, reg, php, js, htaccess, htpasswd, gitignore

...
Wait please