I'm afraid unless someone here is feeling generous you are going to have to 1) get the price feeds, 2) do the maths according to your own flavouring and 3) make it robust to all the errors, data failures and other issues that are part of real trading.
If you have problems with 1) or 3) we are definitely the right place to ask. 2) is more of a personal choice.
Hi all - new to this forum, hoping to learn a lot here!?
Wondering if anyone has been able to use the excel API to pull in Beta to the S&P500 for a particular stock that is in your portfolio? I am looking to calculate a beta-adjusted equity exposure figure for each position.