Hello,
This is my first post, I searched through the forum a little and didn't see a similar question but if I missed it, please feel free to link.
I'm looking to put together a data system through and an API (ideally using Excel) to follow special situations taking place in public markets. I plan to use IB to execute trades but would like to know if there are better and more user friendly alternatives out there.
Ideally, the data/information feed(s) would provide me with access to
From all this data I'd like to have it hook up through an Excel API and be able to create a list for each type of situation (each on separate sheets in the same workbook) and make some simple calculations with the bid-ask quotes of the company's securities. I don't need the fastest speeds in the world since these trades will take place over several months to a year but I would like to be able to search through a lot of different companies on different lists so I presume it still needs to be a powerful/fast API. I know some of this information is obscure and might be costly but I'd like to take a look at my options.
Thank you for any and all assistance! This is my first time setting up a system such as this so if I said anything incorrectly or could be doing something more efficiently please let me know.
This is my first post, I searched through the forum a little and didn't see a similar question but if I missed it, please feel free to link.
I'm looking to put together a data system through and an API (ideally using Excel) to follow special situations taking place in public markets. I plan to use IB to execute trades but would like to know if there are better and more user friendly alternatives out there.
Ideally, the data/information feed(s) would provide me with access to
(i) Special situations lists (bankruptcies, spin-offs, recapitalizations, m&a activity, and SPACs)
(ii) Top-of-book real-time quotes throughout the company's capital structure (loans, bonds, convertibles, preferred equity, common equity, & warrants). Bonds, common shares, and warrants being most important
(ii) Top-of-book real-time quotes throughout the company's capital structure (loans, bonds, convertibles, preferred equity, common equity, & warrants). Bonds, common shares, and warrants being most important
From all this data I'd like to have it hook up through an Excel API and be able to create a list for each type of situation (each on separate sheets in the same workbook) and make some simple calculations with the bid-ask quotes of the company's securities. I don't need the fastest speeds in the world since these trades will take place over several months to a year but I would like to be able to search through a lot of different companies on different lists so I presume it still needs to be a powerful/fast API. I know some of this information is obscure and might be costly but I'd like to take a look at my options.
Thank you for any and all assistance! This is my first time setting up a system such as this so if I said anything incorrectly or could be doing something more efficiently please let me know.
