Discussion Forum

Hi Joel,

Do you have a specific algorithm in mind that will require taking this information into account? If so, feel free to share it and that will give us a good idea of what you are trying to do with/to accommodate DST. Outside of that, I can tell you that our Forex data comes from either Oanda or FXCM, depending on the market specified by the user in an algorithm. Oanda data is time-stamped in UTC time and so New York and London will shift from UTC-5 to UTC-4 and from UTC to UTC+1, respectively, when they move into Daylight Saving Time. FXCM data is time-stamped at US/Eastern Standard Time, or UTC-5. You can find more information on our data hours/time zones here and here.

Hi Jack

Thank you for taking the time to reply. I have attached a bare-bones backtest (using FXCM data, so US/Eastern Standard time). Ultimately what I want to code is a "London breakout" algorithm for Forex, so I need to know when it's 8 am in London. This backtest doesn't have any trading logic, it just does the following:

1) prints a dot on the chart for the value of "GBPUSD" at 3 am (well it should be 'SeriesType.Scatter', but it's printing as a line in my Algorithm Lab). Should be Blue for no DST, Green for NY = DST, Red for both NY and UK = DST.

2) when the current hour is 3 am, the string "3 am" is printed to the log (log output pasted below)

Basically, what I can't figure out is what time is 8 am in London with respect to the timestamps in the log. I understand that when neither location is in DST, 3 am EST is 8 am in London. However when New York is in DST, 3 am prints as 4 am in the log. Is 8 am in London still 3 am in the log, or is it now 4 am? When both locations are in DST, is 8 am in London now 4 am in the log or has it returned to 3 am?

** A note about how I have coded the backtest. It uses 'Resolution.Second' data and a custom consolidator to produce hourly consolidated bars. This is because the algorithm I want to code needs to make trading decisions every second but also relies on hourly SMA values.

Regards,
Joel

P.S. I don't know if the time of each data point is displaying correctly here... I'm seeing them as 8 am after  I attached the backtest (and I'm in Australia, so not even my local time for 3 am EST New York)

--------

Hi Joel,

So the default timezone for the timestamps in the logs is US/Eastern (i.e., New York) but this is not fixed, and so the timestamps show the switch from UTC-5 to UTC-4. This closes the gap with London from 5-hours to 4-hours, and so 8 am London time now corresponds to 4 am NY time. When London enters BST, then 8 am London time is 3 am NY time again. So, briefly, the relationship between NY local time and London local time, keeping London time fixed at 8am, is:
 

1) 3am / 8am (UTC-5 / UTC)
2) 4am / 8am (UTC-4 / UTC)
3) 3am / 8am (UTC-4 / UTC+1)

That's great Jack, thank you. I think the confusion is also about sampling in OnData() and how that changes. So I guess I would do:

1)  UTC-5 / UTC:    sample at 3am in OnData() = 3am in timestamp = 8am London
2) UTC-4 / UTC:    sample at 3am in OnData() = 4am in timestamp = 8am London
3) UTC-4 / UTC+1: sample at 2am in OnData() = 3am in timestamp = 8am London

Correct, you can see this in the backtest I've attached where the timezone is set to London. The data timestamp is fixed to UTC-5, and so the QuoteBar.EndTime will be 3am when London is 8am, until London enters BST at which point you can see in the logs that QuoteBar.EndTime is 2am when London is 8am. The timestamps you see in the log is for the algorithm's timezone, and so if you leave it at the default then this will show New York time.