I'd like to be able to plot some data as a time series with respect to real calendar date instead of the financial date of the associated organization(s).
I want to feel confident I'm approaching this correctly - would it be correct to calculate a month offset for each organization according to its fiscal year ending month, and applying that offset to the period and financial year of any of its financial statements to come up with a calendar date? Are there any caveats I need to be aware of?
I'm not very familiar with financial analysis (or calendars) so I'm trying to be cautious.
An additional detail - when querying for statements with period "9M", does 9M refer to Q1->Q3 or Q2->Q4?
Thanks for any help - Patrick