Forum Discussion
Annual Dividend of a company
Without knowing a bit more of your context, it would be hard to give a specific answer. What brokerage (if any) do you work with?
So I can tell you my own practice: I use Fidelity as my brokerage, and make use of their Active Trader Pro software platform to download not only my own portfolio (and the standard view includes such things as ex-div dates and dividends), but also to create custom lists (which would accommodate your 200 symbols) custom lists that include whatever specific data types you might want. I have good reason to believe that most major brokerages offer similar services.
Do you have access to the STOCKHISTORY function within Excel. I think that could be an alternative if it works for you; I have spotty results -- it works on one computer works, not another, despite a common subscription.