| Index | Recent Threads | Who's Online | Search |
|
|
yuvaltaylor
|
Dan, Riccardo, and I felt that the few samples we had for aggregate series didn't fully show off the tool's capabilities. So we've added eleven new ones. You can see them here: https://www.portfolio123.com/app/opener/SERIES?cat=-1 . . . If you sort by date created, you can see which are the new ones and which are the old ones. We're hoping this will inspire some of you to play around with the aggregate series tool more. You can learn all sorts of fascinating things using it; in addition, the series that you generate can then be used in your screens and simulations using the GetSeries command. You can also use them in the macro charts, multi charts, and, using GetSeries, in fundamental charts. Yuval Taylor Product Manager, Portfolio123 invest(igations) Any opinions or recommendations in this message are not opinions or recommendations of Portfolio123 Securities LLC. |
||
|
mm123
|
Very nice, thank you. |
||
|
geov
|
Yuval, while you are at it you should fix "Benchmark - AIRLINES". |
||
|
|
yuvaltaylor
|
Yuval, while you are at it you should fix "Benchmark - AIRLINES". Good catch! We'll do so. Yuval Taylor Product Manager, Portfolio123 invest(igations) Any opinions or recommendations in this message are not opinions or recommendations of Portfolio123 Securities LLC. |
||
|
|
yuvaltaylor
|
The S&P 500 benchmark that we use is simply the ETF SPY. There could be any number of reasons why there might be a slight difference between the ETF price series and the aggregate series produced by a cap-weighted average of all price moves, calculated cumulatively. One is rounding; another is that ETFs track price moves very slightly imperfectly; a third would be slightly different reconstitution dates. You can get a slightly closer approximation by using UnivSum("1","Close(0)*SharesQ")/UnivSum("1","Close(1)*SharesQ"), which would have less of a rounding error; I'm not sure why UnivCapAvg("Close(0)>1","Close(0)/Close(1)") was preferred back in 2014. Yuval Taylor Product Manager, Portfolio123 invest(igations) Any opinions or recommendations in this message are not opinions or recommendations of Portfolio123 Securities LLC. |
||
|
|
geov
|
UnivSum("1","Close(0)*SharesQ")/UnivSum("1","Close(1)*SharesQ") Yuval, it would appear that this rule will create an equal weight benchmark? |
||
|
|
geov
|
Dan, Riccardo, and I felt that the few samples we had for aggregate series didn't fully show off the tool's capabilities. ..............You can learn all sorts of fascinating things using it. Indeed you can. I created custom aggregate series Non-Cyclical & Cyclicals of the S&P1500 and used it together with 3 other series as a market timer described here: https://seekingalpha.com/article/4459097-cons...itable-stock-market-timer. |
||
|
ETFOptimize
|
Yuval: "You can get a slightly closer approximation by using UnivSum("1","Close(0)*SharesQ")/UnivSum("1","Close(1)*SharesQ")..." Thank you, Yuval, that's helpful. (Edit: But I think Georg is right. It produces an equal weight series.) Yuval: "The S&P 500 benchmark that we use is simply the ETF SPY." Without going through them all, under the Benchmarks list, should we assume everything is an ETF - unless it's specifically listed under 'Index' (without dividends) on the right side of the table? Moreover, it's unfortunate that we can't learn what specific ETF is being used until we actually run a Series or a Simulation. It would be helpful if the ETF ticker was put in parenthesis after the designation in the Benchmark table. |
||
Edit 1 times,
last edit by
ETFOptimize
at Oct 8, 2021 9:30:09 PM
|
|
yuvaltaylor
|
Yuval: "You can get a slightly closer approximation by using UnivSum("1","Close(0)*SharesQ")/UnivSum("1","Close(1)*SharesQ")..." Thank you, Yuval, that's helpful. (Edit: But I think Georg is right. It produces an equal weight series.) No, that's cap-weighted because it multiplies price by number of shares. So you're adding up the market caps. Let's say there were two stocks in the universe, one with a market cap of $800 and the other with a market cap of $200, and the first went up to $900 and the second went down to $100. Equal weight would mean that the total return would be the average of 12.5% and -50%. Cap weighted means that the total return would be 0.8*12.5% + 0.2*-50% = 0. And UnivSum accomplishes this. Yuval Taylor Product Manager, Portfolio123 invest(igations) Any opinions or recommendations in this message are not opinions or recommendations of Portfolio123 Securities LLC. |
||
|
|