Hi,
I just purchased a Tickstory License and am now trying to download price data as a csv file which I used to get when exporting to file that looked like this:
Timestamp, HighPrice, LowPrice, OpenPrice, ClosePrice
2017-02-13 00:00:00,0.76738,0.76545,0.76562,0.76641
2017-02-13 04:00:00,0.76692,0.76631,0.76641,0.76649
2017-02-13 08:00:00,0.76697,0.7649,0.7665,0.76605
2017-02-13 12:00:00,0.76917,0.76588,0.76608,0.76803
2017-02-13 16:00:00,0.76982,0.76788,0.76803,0.76937
2017-02-13 20:00:00,0.76983,0.7684,0.76937,0.76913
Now instead I get multiple folders containing bis-files.
Before I purchased the license and was using the free version I was able to export to file and get a document that I could edit in NotePad++ which I'm using to import data into my application.
Please tell me how I can export to file with data structured like above, also please tell me how/if I can download multiple instruments into a single file with information that says what instrument it is besides highprice, lowprice etc?
Thanks
Export to file, csv-file like structure instead of bis
Re: Export to file, csv-file like structure instead of bis
Hi Jobo,
It seems that you are looking in the incorrect folder for the exported CSV file. When you are exporting to file, make sure you specify the full path/location where you would like the file (eg. c:\users\jobo\documents\{Symbol}.csv). The file should then exist in the named folder after the export.
Our manual covers the process in more detail here:
https://tickstory.com/help/tickstorylit ... e_overview
https://tickstory.com/help/tickstorylit ... ta_to_file
Please note that you can export multiple symbols at the same time, however they will not be merged together. You will have one file per symbol (eg. EURUSD.csv, GBPUSD.csv, etc).
If you need to merge them, you will need to use Notepad, Excel or the like.
Hope this helps!
It seems that you are looking in the incorrect folder for the exported CSV file. When you are exporting to file, make sure you specify the full path/location where you would like the file (eg. c:\users\jobo\documents\{Symbol}.csv). The file should then exist in the named folder after the export.
Our manual covers the process in more detail here:
https://tickstory.com/help/tickstorylit ... e_overview
https://tickstory.com/help/tickstorylit ... ta_to_file
Please note that you can export multiple symbols at the same time, however they will not be merged together. You will have one file per symbol (eg. EURUSD.csv, GBPUSD.csv, etc).
If you need to merge them, you will need to use Notepad, Excel or the like.
Hope this helps!
Re: Export to file, csv-file like structure instead of bis
Thank you, solved the problem of getting a .csv file.
Don't really understand how you export multiple files .csv files at once as you need to set a single name for the file to export.
If I highlight two different instruments and choose export to file I can only chose one output file name. If I try to export two instruments to file I only get one of them in the .csv file.
Please explain how I download multiple files Right now I have to do export to file for every single instrument to get individual .csv files.
Thanks
Don't really understand how you export multiple files .csv files at once as you need to set a single name for the file to export.
If I highlight two different instruments and choose export to file I can only chose one output file name. If I try to export two instruments to file I only get one of them in the .csv file.
Please explain how I download multiple files Right now I have to do export to file for every single instrument to get individual .csv files.
Thanks
Re: Export to file, csv-file like structure instead of bis
Hi Jobo,
The beauty of the export function is that you can use a special token called {Symbol} to create a filename based on the symbol you are exporting. When you do this, the multiple symbols you selected will automatically be named. For example, if you have selected both EURUSD and GBPUSD for export, the filename {Symbol}.csv will produce EURUSD.csv, and GBPUSD.csv. There are also other special tokens which are documented in the manual.
Hope this helps!
The beauty of the export function is that you can use a special token called {Symbol} to create a filename based on the symbol you are exporting. When you do this, the multiple symbols you selected will automatically be named. For example, if you have selected both EURUSD and GBPUSD for export, the filename {Symbol}.csv will produce EURUSD.csv, and GBPUSD.csv. There are also other special tokens which are documented in the manual.
Hope this helps!