Download market capitalization at period end date

libacq

Hi. I am trying to download companies' market capitalization at fiscal period end date. However, for all companies the fiscal quarter end date is set at the same dates (3, 6, 9, 12). How might I fix this?

Due to the amount of data I need to download, I cannot download monthly data for all stocks. (I don't need the fundamentals and market cap data to be aligned, but I do need the market cap data to be at the correct period end date.)

Many thanks!

rd.get_data('JP3322110002',  ["TR.CompanyMarketCap.date", 'TR.CompanyMarketCap','TR.TotalAssets','TR.TotalAssetsReported.date'], parameters={'SDate': '2018-01-01', 'EDate': '2024-5-1', 'FRQ': 'FQ', 'Scale':6})

Jirapongse

@libacq

Thank you for reaching out to us.

You can use the Data Item Browser tool to list all available parameters and values for each field.

Otherwise, you can contact the helpdesk team direclty via MyAccount and ask for the fields and parameters that can be used to retreive the required data.