You could try using DoubleToStr but that might not give you what you want in Excel . . . why don't you just fix it in Excel ?
RaptorUK:
You could try using DoubleToStr but that might not give you what you want in Excel . . . why don't you just fix it in Excel ?
You could try using DoubleToStr but that might not give you what you want in Excel . . . why don't you just fix it in Excel ?
Yes, I am doing it in Excel using Excel functions =RIGHT(), =LEFT().
I wanted to save some muda as I transfer data to Excel quite often.
I will try your suggestion with DoubleToStr! New function for me so I will try!
Maybe I will fix it by myself, that would be the best!
Thanks
FileWrite(handle, Ticks[i], " at ", TimeHour(Times[i]),":", TimeMinute(Times[i]));
Don't write extra info, let excel separate the price from the datetimeFileWrite(handle, Ticks[i], TimeToStr(Times[i]));
and then import it. You might want to use a comma as the separator.- Easy to just select the price column and add a zero then remove the zero - all prices are now equal.
- Print the price with full precision
DoubleToStr(ticks[i], Digits)
WHRoeder:
-
Don't write extra info, let excel separate the price from the datetime
and then import it. You might want to use a comma as the separator.
- Easy to just select the price column and add a zero then remove the zero - all prices are not equal.
- Print the price with full precision
Thank you WHRoeder!
This is excellent solution!
You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
Beginner's question:
I wrote single code to record and export price data (all recorded ticks) into Excel:
One thing that annoys me is the recorded data is not lined up (see below) and I cannot solve this!
It writes me 1.451 instead of 1.4510!
Also the time: If daily Hour / Minute is one digit only it writes 13:8 instead of 13:08!
I know it's silly cosmetic issue but I have spent so much time with that...
Pls, can somebody correct my code so that it does better job?
Thanks in advance...