This could be a design issue or maybe there are some more efficient tools or path I'm not aware off. Below is my thought start from scratch but any other idea is greatly appreciated.
1. download store portfolio positions
2. download and store prices of each position very often.
3. calculate the portfolio total value at each sbapshot (daily)
4. calculate sharpe ratio based on the daily portfolio value. and store it.
The final goal is I can flexibly compare the sharpe ratio of current portfolio and a proposed alternative strategies.
1. download store portfolio positions
2. download and store prices of each position very often.
3. calculate the portfolio total value at each sbapshot (daily)
4. calculate sharpe ratio based on the daily portfolio value. and store it.
The final goal is I can flexibly compare the sharpe ratio of current portfolio and a proposed alternative strategies.