Hi All.
Does anyone know of a product or have a spreadsheet which would allow us to merge multiple sims into one single equity curves or report?
Since many, if not all of us, run mutliple portfolios it would be great to plot multiple ports or sims into one chart or report to test our overall multi-systems performances.
Any suggestions? My Excel skills are basic.
-Stefano
Stefano,
You can most definetly use Excel for that pretty successfully.
I did that a couple of times especially when we did not have Sharpe calculation and genelar quality of the performace wa difficult to tell by just annual return etc.
So I did exactly that - plot the curves with one and the same startign point.
Let me find some time. I will put a short explaination what I did. Others might have done that too.
I would encourage you to use any opportunity to learn Excel. There is tons of books on it. And even more tons of online info.
Vlad
I post all of my trades into the Portfolio Manager(PM) which is part of the AIQ software package. If you don’t have any other use for AIQ, it probably wouldn’t be worth it to get AIQ just for the PM feature. You can create multiple portfolios in PM and then also put them under a consolidated account and get all the statistics. See attached individual graphs and the consolidated graph.
I have four P123 portfolios running and I have also been tracking these in AIQ’s PM. The attached graphs have very little history since my P123 portfolios are not very old. As a result, the annualized results are not likely to come true once the year is over.
I think it wouldn’t be too hard to combine the portfolios in Excel but I haven’t yet tried.
This would make a good feature request for P123.
I attached a spreadsheet that I use to combine the backtest results from several sims into a single portfolio. It has the equity curve, drawdown charts, etc. It might be a little hard to figure out if you dont know Excel well. There was another thread on this about a year back, but the attached file is a newer version.
Sim combinations worksheet-enhanced.xls (3.68 MB)
Dan,
thanks for putting these tools out there. I appreciate you helping out with this and other things. I hope to contribute in the future, to give something back.
Michael
All,
For those of you that want the capability to sum multiple Ports into a Master Port within P123 vote for this Feature Request;
http://www.portfolio123.com/mvnforum/viewthread?thread=441#1251
And this one;
http://www.portfolio123.com/mvnforum/viewthread?thread=751#2245
Denny 
Dan. This is great. More then I was looking for but needed.
I have one question. I run three ports. Your sheet has seven. Whats the best way to exempt unneeded port colums? I simply inputed "0"s in the unneeded port data cells. Is this correct?
Also, I remember a year or so ago P123 created a document sharing directory somewhere. Does anyone know if its still availible and being used?
-Stefano
If you have 3 ports, then just fill in the history for the 3 ports starting in row 65. Then allocate the % to the 3 ports so that the % adds up to 100%. You do that in cells B3 through B9. All the cells that are shaded blue need input from you.
There is a Yahoo group setup for P123 which allows you to attach files, but nobody uses it anymore since we can now attach files to our posts on this site.
Nick from the Portfolio123 staff sent me an email and pointed out a flaw in the spreadsheet’s logic. Below is what he wrote:
"…you assume that there is daily rebalancing of the portfolio of portfolios by multiplying the daily ending equity of each portfolio by its weight. Perhaps to more accurately reflect reality is to assume no rebalancing by multiplying only the individual portfolio’s starting equity by its weight. The equity curves will then be weighted at the start, but as each equity curve grows at its own rate, at the end of the simulation period, the weights should not be the same. "
This should not be hard to fix, but I dont have time right now. In the mean time, I thought you guys should be aware of it.
Dan,
Thanks for letting us know. However, I do try to keep my portfolios balanced, so at the beginning of each month I adjust each of my ports’ total balance by adding or removing cash, so that all ports have equal weight. So your current version of this spreadsheet does work correctly for my case.
Brian
Hmmm. This fix is over my head. Can some explain how to update my sheet ;-}
-Stefano
I could use some help also.
Thanks,
Kit
The excel provided by dan is great. I am new to p123 and was wondering where you got the daily $ balances from in p123? There must be some type of export, correct?
Thanks,
Julien
Julien,
In either Sims or Ports, go to Performance; Charts, in the left column.
In the top right corner of the chart is a small download button.
This will automatically download the daily info into Excel.
Denny
great! Thanks for the reply. I actually just figured it out and was going to post the solution for someone else to read if no replies had been given.
