question

Upvotes
Accepted
1 0 0 0

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

Upvotes
Accepted
52.9k 136 44 63

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