New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
libacq avatar image
3 ●0 ●0 ●2

Download market capitalization at period end date

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})
1719993754081.png


pythonworkspace#technology#contentrefinitiv-data-libraries
1719993754081.png (90.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
87.8k ●294 ●53 ●79

@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.

1720083836068.png

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.


1720083836068.png (58.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.