Page 1 of 1
Create a seperate csv file for each day
Posted: Tue Aug 02, 2016 9:31 am
by dmoan
Hello,
I need to convert the data I downloaded to csv files, and I need a different file for each day.
Is there a way for Tickstory Lite (or Pro, for that matter) to produce them automatically when selecting a range of dates?
I tried adding {Timestamp:yyyy-MM-dd} to the output file name, but it keeps being created only with today's date.
Thanks,
Noam
Re: Create a seperate csv file for each day
Posted: Tue Aug 23, 2016 10:20 am
by tickstory
Hi Noam,
Have you checked out our videos on exporting files:
https://tickstory.com/articles/how-to-d ... ical-data/
https://tickstory.com/articles/how-to-d ... tick-data/
There is also a section in the manual which explains the various settings.
If you are continuing to have issues, please send a screenshot of the issue.
Thanks.
Re: Create a seperate csv file for each day
Posted: Tue Aug 23, 2016 11:59 am
by dmoan
I have watched the video and read the manual but found no answer.
you can see in the attached image the format I use for the filename:
{Symbol}_Tick_{Timestamp:yyyy-MM-dd}.csv
where the tokens were taken from the Tick menu.
To my understanding, that should create a different file for every symbol and every day.
however the filename I actually get is:
AUDUSD_Tick_2016-08-03
that is, with today's date, and containing the entire span of dates I've chosen (from the 15 to the 17)
Thanks!
Re: Create a seperate csv file for each day
Posted: Tue Aug 23, 2016 7:35 pm
by tickstory
Hi Dmoan,
I see what you're saying. No, the date relates to the current date - not the exported data's timestamp. If you were to produce an extract each day then the filename would change accordingly for each day. It will not, however, produce separate files for each day of the exported period. For this you will need to utilise Excel or the like.
If you have a particular requirement around producing files, please let us know in the 'Suggestions" section. We typically prioritise suggestions based on popularilty with our users.
Regards.