We have a list of equity tickers in an excel spreadsheet (column of 100 unique names) - tab 1. We also have a tab 2 that when we enter an equity ticker, data is pulled from Bloomberg via excel formulas. After tab 2 has done its calculation, we copy certain data from tab 2 to tab 1, next to the ticker we copied. Then we go to the next ticker in the list and repeat. I want a macro to do this, so if we go to a list of 200 or 300 names we have that flexibility.
60 freelancers are bidding on average $126 for this job
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only. Stay tuned, I'm still working on this proposal.