edgars.rworks:
Q:How can I actually move over days in such maner because only thing that I can get form Datetime is such numbers 1376265600 that stands for each day?
this is unix timestamp, time in seconds. substract 86400 to get the previous day.
(86400=60 sec * 60 min * 24 hour)
szgy74:
this is unix timestamp, time in seconds. substract 86400 to get the previous day.
(86400=60 sec * 60 min * 24 hour)
Wow, tnx it helps a lot :)
Do You have some ideas to second Q ? :
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
Hi.
I created programm that analyze multiple currency pairs and store results in Excel file. The output format is like this: GBP;CHF;USD;EUR;JPY and from left to right strongest to weakest Symbol.
Now I want to somehow analyze that data and get information how often that one combination have been( I know how to do that) . But most important I want to see and count how often other combinations come out in next days.
Example:
1.day GBP;CHF;USD;EUR;JPY
2.day CHF;EUR;USD;JPY;GBP
3.day JPY;USD;CHF;GBP;EUR
4.day EUR;GBP;CHF;JPY;USD
1.day I have that combination, programm remembers it and go to next 3 days and count all combinations next on programm searches over all excel file for 1.days combination and again saves next 3 days combinations. After that It goes back to start but one day forward (2.day) and repeats all cycles.
Q:How can I actually move over days in such maner because only thing that I can get form Datetime is such numbers 1376265600 that stands for each day?
Q2:How can I achieve such thing that. I understand it is hard code because consists from masive cycle, but does somebody have other Ideas to achieve this ? I don't need full code I need some advice or tip to start with.
I added my source code, maybe it will help to provide some ideas :)
Thanks :)