When I open a weekly chart of various markets the weeks are date tagged showing the end of the week being of Friday and so presumably the week starts start on Monday. Seems perfectly logical, except not all markets do that:
US stocks and commodities in the first half of the 1900s traded on Saturday, so logically the week should end at the close of trading on Saturday and the Weekly Chart bars dated accordingly, but they show Friday's date.
I have historical CSV files of US Stocks and commodities that also traded on Saturdays - their weekly charts in Optuma also shows the week ending on Friday, presumably adding the Saturday details into the following week, but that is not clear.
Australian futures contracts trade over night on Friday/Saturday morning, which begs the question - is that data treated as part of Friday or Monday for the purpose of the Weekly bar?
US futures contracts trade overnight Sunday/Monday morning, so presumably they are treated as all being in Monday.
Logically, when trading days continued into Saturday, as they did in the first half of the 20th century, it is logical for the week to end with the close of trading on Saturday and start with the opening of trading on Monday. To do otherwise could result in mis-leading weekly bars if a weekly high/low occurred on a Saturday. It could also impact monthly bars when the change of months occurs over the weekend.
Please clarify how Optuma treats historical Saturday trading and the current cut-off day for the week, in particular with regard to Australian futures contracts.
Is there a way to define the Start/End of the week (or month) for the historical data that traded on Saturdays?
I didn’t realise my question was such a hard one to respond to☹
With historical charts (and Bitcoin XBTUSD which trades 24/7) it seems to me illogical that the week ends on Friday and starts on Saturday, when historically trading for the week ended on Saturday. Is there a way the end/start of the weekly bars can be set by the user?
If you want to check what the start / end of a weekly bar is using you can setup a generic rolling CSV code of Monday - Sunday bars using dummy values for a few weeks and import it into Optuma.
You can then compare daily to weekly values to see what is being used for Open and Close of the weekly bars.
Here’s an example, it shows that the Weekly bar begins on a Saturday, and ends on a Friday…
There is no way in Optuma to override this (having a weekly bar begin from a different day), it’s built into the data management of Optuma. If it’s something you’d like to request as a feature please add the details via the Feature Request section of the forum.
