logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
johnnydrako  
#1 Posted : Wednesday, November 16, 2005 1:15:31 PM(UTC)
johnnydrako

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!
johnnydrako  
#2 Posted : Wednesday, November 16, 2005 1:30:13 PM(UTC)
johnnydrako

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.
StorkBite  
#3 Posted : Wednesday, November 16, 2005 11:21:32 PM(UTC)
StorkBite

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. :(
johnnydrako  
#4 Posted : Thursday, November 17, 2005 12:15:40 AM(UTC)
johnnydrako

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".
StorkBite  
#5 Posted : Thursday, November 17, 2005 2:04:46 AM(UTC)
StorkBite

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)
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.