A.I.M. Users Bulletin Board

[ls7550]

Re Newport and loading historical prices

Thanks Tom. Suspected it was something like that for those two odd fields.

Here's one way to preload a new Newport stock with historical prices

Create the new Newport AIM in the normal manner (so that the .HST file is created)

Download WEEKLY historical prices from yahoo for the last few years, saving into Excel

http://finance.yahoo.com/q/hp?s=^DJI

In Excel select Cell A1 and sort ascending (DATA, SORT, ASCENDING)

Paste the following formulas respectively into cells i2, j2, ... onwards

=CONCATENATE(TEXT(MONTH(K2),"00"),"/",TEXT(DAY(K2),"00"),"/",TEXT(RIGHT(YEAR(K2),2),"00"))
"
=A2-1
=B2
10
0
0
=L2*M2
20000
=CONCATENATE(J2,I2,J2,",",L2,",",M2,",",N2,",",O2,",",P2,",",Q2)

The second value is a double quote that is used to wrap around the date.

The third value adjusts the date to Sunday

The 10 value in the fifth formula represents the number of shares, you should change that to however many shares you initiated the new AIM with. Similarly the 20000 value in the ninth formula represents the cash reserve which should be changed to reflect the cash reserve allocated.

Select those i2 to r2 cells and COPY, then highlight from cell i3 down to the last row and PASTE

The rightmost row should then contain the Newport .HST file format. Select that columns values and
COPY, open a Notepad and Paste, then save that file to the .HST filename of the newly created AIM.

Of course there's no AIM trades made over that period, but it's nice having the historical price graph and moving average to look at within Newport.

Regards.
Clive.