| Index | Recent Threads | Who's Online | User List | Search |
|
|
 |
Portfolio123 » List all forums » Forum: Latest Release » Thread: Dividends will now be automatically added to running portfolios |
|
Total posts in this thread: 15
|
[Request a Feature] [Add To My Favorites] [Watch this Thread] |
| Author |
|
|
marco
|
You should start seeing dividend transaction in your running portfolios by tomorrow. When we update the prices (around 10PM currently, but will be 7PM soon) we do these additional steps: - We check for holdings that have dividends with ex-date of the day of the update. - If a dividend is found a dividend transaction will appear for that stock with an amount of 0$. The note on the transaction will say when the pay date is. - On the pay-date of the dividend the cash will be added to the portfolio Marco NOTE: Dividends in simulations will soon be available. ---------------------------------------- Portfolio123 Staff |
||
|
|
dwpeters
Advanced Member
|
This is big news, thanks. I look forward to testing sims w/ dividends. Don |
||
|
|
sbsnyder
Advanced Member
|
Yes, this is great news! I am assuming, but would like to confirm, that dividends will be correctly calculated in the return percentages and not treated as a cash addition. Thanks!!!  |
||
|
|
jackdiaz
Member
|
That is amazing and quite helpful but What if when the dividends are calculated as cash?  ---------------------------------------- Tim Manning |
||
|
|
marco
|
Correct. The dividends will affect the total return of the port. However it does not change the return of the position. For example the Sell function GainPct does not take the dividend into account. However... when dividends will be incorporated in sims they will also be incorporated in the price series, so if you use price functions like Close(0)/Close(20), the ratio will include any ex-date dividends. ---------------------------------------- Portfolio123 Staff |
|||
|
|
marco
|
Not sure what you mean ---------------------------------------- Portfolio123 Staff |
|||
|
|
z8735
Advanced Member
|
fantastic news Marco, thanks! There are many questions about how it will affect different functions. I guess It would be best to start testing (especially when available in Sims). Or if there a document outlining the way divs will behave ? Thanks much for great work, Z. |
||
|
|
tiltonhouse
Advanced Member
|
This is a great addition. I am also interested in hearing how this might be added to Sims in the future. |
||
|
|
marco
|
Dividends in sims should work the way you expect them to. Ex: added on ex date, paid on pay-date, etc. The main thing about dividends in simulations is that the price data is adjusted for dividends. The adjustment is made on the ex date since that is when the price takes a dive depending on the size of the dividend. This makes things like moving averages work avoiding false signals. We were debating whether to adjust price data only for Special dividends since those are typically large (ex. Microsoft $3 special dividend on nov 2004) but decided to do it for all dividends. We noticed that popular TA sites like StockCharts use price series fully adjusted for divs. The way the price is adjusted for dividends is using the previous day close and the amount of the dividend to come up with a pseudo split. Dividends in sims is expected to be live sometime next week. ---------------------------------------- Portfolio123 Staff |
||
|
|
z8735
Advanced Member
|
Hi Marco, So when is the cash added to the port, if at all? Here is a scenario, how would it work? Someone had $3500. He bought 100 shares of LYB on Nov 7 2011 on the open for 34.9. On Nov 21 the stock closed at 34.5 . It went ex-div (dividend of $4.75) and opened on Nov 22 for 29.5. It currently (Close of this Friday 12/16/2011) fetches $32.05. The buyer who paid $34.9 lost $2.85 on the stock (32.05-34.9), but gained $4.75 on the dividend, so his net holding is 100 shares of LYB (loss of $285) and cash of 3500-3490+475=$485. Net assets value = 3205 + 485 = 3690, so the net gain for the period is $190 Is the following a correct description how the scenario would play under the new Sim and Port capabilities: A port starts on Nov 7 with $3500 of cash. It buys 100 shares of LYB for an adjusted $30.15 on Nov 7 open (34.9 - 4.75 = 30.15) so the port holds 100 shares and $485 cash as of Nov 7 close. There is no gap in price on Nov 22, and therefore on 12/16 close the current value of $32.05 means that the stock appreciated by $1.90. The port's current value is 3205 + 485 = $3690. There was no change in the port's cash holdings at any time after the position was opened, no cash was added. Marco, is the above correct, and if so, how does it fit with the statement regarding pay-date?
Thanks, Z ---------------------------------------- [Edit 3 times, last edit by z8735 at Dec 17, 2011 1:24:30 AM] |
|||
|
|
[Show Thread Printable Version] |
