Discussions
»
Community Forums
»
General Chat
»
Data Question -- non-MetaStock
Rank: Newbie
Groups: Registered, Registered Users Joined: 11/16/2005(UTC) Posts: 3
|
Hello,
I wish to begin backtesting a trading system manually in good ol' Excel using weekly closing data for PG. The data I have came from Yahoo and my confusion comes in regarding the Adjusted Close figure.
* To accurately test, do I need to also have the calendar of splits and dividends?
Specifics:
Let's say I'm testing for a hypothetical 100 shares starting at the beginning of the spreadsheet, which is January 2, 1970. On that date, the "real" weekly close was 110, but the adjusted close was 0.63. Will I be safe just using the adjusted close throughout, all the way up to the present date, assuming the same 100 shares throughout?
Thanks in advance!
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 11/16/2005(UTC) Posts: 3
|
To amend my previous message:
The way I see it:
1) If I use the Adjusted Close, I will also need to convert the weekly high and low data (the two other data points required in this trading system) in order to compare apples and apples
2) If I use the "actual" close, then I *will* need to adjust for splits.
Either way, it sounds more complicated than it should be. All suggestions will be appreciated.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 3/19/2005(UTC) Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hey JD-
Welcome to the Equis forum!
Are you wanting to know how Yahoo adjusts their closing price? Maybe that should be addressed with Yahoo. Are you importing this data into MS for use? Concerning your attached document, how does it relate to the Yahoo data question? I'm missing the point... and the permission and copyright notice for the TASC article that you are referencing. :(
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 11/16/2005(UTC) Posts: 3
|
Thanks for the welcome!
>>Are you wanting to know how Yahoo adjusts their closing price?
I was assuming that I am not the first person to have to deal with this issue, so I hoped someone here would have some wisdom in this regard.
>>Are you importing this data into MS for use?
No. As I mentioned, I am looking at the data in Excel.
>>Concerning your attached document, how does it relate to the Yahoo data question?
I attached a copy of the system I wish to test simply as a FYI for anyone who's interested.
>>I'm missing the point... and the permission and copyright notice for the TASC article that you are referencing.
Now I'm the one who's confused ... I don't know what you're referring to here. I don't know what TASC or what article you say I am referencing. :?:
Please let me know if my inquiry is inappropriate to this forum. I found the forum by searching google for "mechanical trading system forum".
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 3/19/2005(UTC) Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Check out this link for a description of Yahoo's adjusted closing price. I suspect that you will be having to maintain this manually, but perhaps not. My only experience with Excel and free data providers lies with using MSN Quotes and I don't think that helps address your question.
Check out some of the newsgroups such as misc.invest.stocks; misc.invest.mutual-funds; and, microsoft.public.excel.misc. There are a fair number of queries similar to yours posted there. This forum focuses on the support and education of users of Equis products and 3-party add-ons.
Quote:Trading System from past issue of Technical Analysis of Stocks & Commodities
My confusion lies in your file description and the scope of your question.
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Community Forums
»
General Chat
»
Data Question -- non-MetaStock
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.