question

Upvotes
Accepted
1 0 0 1

how to export 'Mergers&Acquisitions'?

Hi

How do I use python query Mergers&Acqusition into the excel table? Please see attachment.screen-shot-2022-03-10-at-30421-pm-min.png

pythonexcelexampleexport
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
78.1k 246 52 72

@andygocandy

You can use the get_data method in the Eikon Data API to search for M&A deals based on the criteria set. For more information, please refer to the answer on this thread.

The result will be the Pandas data frame. Then, you can use the to_excel method to write a single object to an Excel .xlsx file.

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.