No Dividend/Split adjustment reflected in PricePane
Author: lookingbackon
Creation Date: 4/6/2011 11:16 AM
profile picture

lookingbackon

#1
Hello,

I Activated the "Perform Dividend Adjustment" and "Perform Split Adjustment" in the "Create a new Dataset -->Yahoo! Data". But all price bars still show without adjustment. Meanwhile, in the "Optimization Performance" report, the "Dividends Received" always show "0" both for "All Trades" and "Buy&Hold".

What could be the problem and the potential solution on that? Thanks
profile picture

Cone

#2
What's the symbol? It sounds like Y! isn't providing dividend information for it.

If you're using the price adjustment for dividends, you should disable "Apply Dividends..." in the Backtest settings, per the User Guide. (But it was a good idea to enable this for the purpose of troubleshooting.)
profile picture

lookingbackon

#3
The Symbols are China stocks with .SS and .SZ
No matter the
QUOTE:
"Apply Dividends..." in the Backtest settings
is enabled or disabled. It seems like no adjustment is there.
profile picture

Cone

#4
Since I'm not familiar with any Chinese tickers, it sure would help to get one that you're looking at. If Y! doesn't provide the dividends, then the adapter can't either. Have you looked at the data history on Y! to see if dividend events are included?
profile picture

lookingbackon

#5
For example:
symbol: 600045.SS
divident and split on Nov-12th,2006: split 15 for 10

This would bring huge difference on the test result.
Thanks
profile picture

Eugene

#6
This is an invalid symbol, couldn't be found on Y! Finance site.
profile picture

lookingbackon

#7
The symbol with the data was downloaded from Y! via Data Manager of WLD.
Pls just try another symbol: 000998.SZ, 600030.SS

The issue is that we need to clarify whether the Y! actually provide the data adjustment or not? If not,then we gonna explore another solution for more reliable data.
Thanks
profile picture

Cone

#8
Those 2 symbols work. Let's look at the last dividend for 600030.SS, for example. Here's the data from Y!: The last column is Y!'s adjusted close, and I re-ordered it to be chronological top to bottom.
CODE:
Please log in to see this code.


Here's the NON-adjusted data in WLD/P:
CODE:
Please log in to see this code.


And here's the adjusted data in WLD/P:
CODE:
Please log in to see this code.


It's very clear that the 0.50 dividend is being applied, however the gap in this data by the provider seems to imply that another event took place on this date that is not reflected in the data. Nonetheless, you can repeat this exercise for earlier dividend events and see that Wealth-Lab is properly adjusting for dividends/splits based on the provider's data.
profile picture

lookingbackon

#9
Thanks for the clarification. The data showed in my chart is same as your.

But I think my understanding on the adjustment is with different view. My issue is as below:

for 600030.SS as example:

- If I entried a position of 100 shares on Jun-22 with entry price of 20.14(assume these shares were eligible for divident/split on Jun-24)
- On Jun-24th, there was actually a split of 10 for 15 and 0.5 divident. So the consequency was that I had 150 shares with close price of 13.62 and divident of 50 in my account by Jun-24.
- If I conduct a strategy test/calculation and the position SellAtClose(13.18) on Jun-25. In my test practice, the WLD can't automatically change neither share number(from 100 to 150) nor the Close price and the actual test result would be : Loss: -34.55%=(13.18/20.14)-1 for 100 shares.
Obviously we need to resume the price data before Jun-24th to match the split.

Here comes to my question:
- Is it possible to automatically resume("adjust") the price data(before Jun-24 in this case) with unchanged share number(keep 100 shares in this case) to match with the split/divident and reflect in the test result? Or WLD can detect the share change?
- Or I have to mannually "Process a stock split" one by one to re-adjust the price data so that the test results can be proper?

Sorry for a long description althrough I tried to get it simple. Hopfully my question is clear. But it's critical for the backtest. Thanks
profile picture

Cone

#10
Data is everything. The problem is that the provider is not aware of the split and therefore the adapter is not either. Nonetheless, you should be able to right-click the chart and manually process a stock split action, but that's not working correctly for Y!, so we'll have to see if that can be fixed.

I'll add that these types of adjustment problems are frequent for non-U.S. stocks for Yahoo! I'd recommend looking for a paid, dependable provider for your primary markets and use Y! as a backup.
profile picture

lookingbackon

#11
Thanks for addressing the problem and hopefully WLD would develop better solution in addition to non-free data source.
Regards
profile picture

lookingbackon

#12
By the way, I got another issue for the Y! data.
Currently, the Y! data is actually 2 days late compare to the real-time data. So my question is whether it's possible to manually create a new bar before it's available with Y! data?
Thanks
profile picture

Eugene

#13
1 - There already are many free and paid data sources (hint: check out the Extensions section > Providers).

2 - It's generally possible to add/remove/edit a bar by double-clicking the chart (Edit Bar Data dialog). I guess what you're talking about is a temporary issue at Y!
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).