Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/13/2010(UTC)
Posts: 24
Thanks: 1 times
|
Hi,
I need dow jones metastock data from 1900...I have only close...I need completed data:high-low-close...open is not important.
Thank's in advance
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
I *think* that particular index is included with the Data CD that comes with MetaStock; look in the Indices & Indicators folder. Norgate supplies it with a subscription; it might come with the free trial. You can get back to 1928 at Yahoo. Otherwise, scout around on the web.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London
|
Johnathan is right - I have this data from the Historical Data CD also.
If you don't have this, you can download data from 1920 from Pi Trading dot com for free.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/5/2006(UTC)
Posts: 129
Location: Norgate Data
|
Norgate/Premium Data has the Dow Jones Industrial Average back to its inception in May 1896 contained within our US historical data.
Note that the Dow Jones Averages changed the way they calculated the high-low range of the average in January 1992. It was originally calculated a a "theoretical" high, which meant that the constituent stocks were all assumed to hit their high and low points at the exact same instant. This resulted in longer than "actual" highs and lows, since not all stocks hit their highs/lows at the same time of the day.
|
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/13/2010(UTC)
Posts: 24
Thanks: 1 times
|
OK...thank you very much to all!
I have also an ascii file in wordpad but I can't convert it...
this is the format:
1901 01 02 1200 51.6018000 51.6018000 51.6018000 51.6018000 0 0
1901 01 03 1200 49.7924000 49.7924000 49.7924000 49.7924000 0 0
1901 01 04 1200 50.7887000 50.7887000 50.7887000 50.7887000 0 0
1901 01 05 1200 49.5800000 49.5800000 49.5800000 49.5800000 0 0
1901 01 07 1200 49.1697000 49.1697000 49.1697000 49.1697000 0 0
1901 01 08 1200 49.5580000 49.5580000 49.5580000 49.5580000 0 0
1901 01 09 1200 49.4701000 49.4701000 49.4701000 49.4701000 0 0
etc...etc...
I think 1200 is 12 o'clock..it is the same for all the file...but the file is daily format...thank's in advance for helping me!
I am reading 45 YEARS IN WALL STRETT and I want create charts using price and time as Gann writings....
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London
|
It seems that the Open, High, Low and Close are the same. Is this the same for the whole file? If not, follow these instructions on Excel:
1. Copy the above data into Column A
2. Replace all spaces with commas
3. Copy this formula to Column B all the way down to the last row:
=LEFT(A1,4)&MID(A1,6,2)&MID(A1,9,3)&RIGHT(A1,LEN(A1)-16)
4. Copy Column B into a text file.
5. Add the following header (to line 1) to the text file:
<date>,<open>,<high>,<low>,<close>,<volume>,<o/i>
This can now be converted using The Downloader. I removed the time as it is EOD.
Have a look at the Left(), Mid(), Right() and Len() functions in Excel - that's what I used. This could help you in the future.
|
|
|
|
|
|
| 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.
