RE: Converting traded stocks list to Excel

[RIFKI@xxxxxxx]

Ike Murphy wrote  Tue, 1 Jul 1997 10:19:24 -0600

> Rifki,
> I am not sure I understand what I am looking at. What do those numbers
> represent? Is this tick data?
> 
> Ike Murphy
> Equis Support


Ike

Well, I guess you could call it Tick data. Only we don't have tickers 
or even data providers here. The Sri Lankan stock market, from ehere 
the data is, trades only around a 100 stocks each day. All the stocks 
traded from the opening bell to the close are published in 
chronological order in the daily newspaper the following day. What I 
have been doing so far is to manually enter the O,H,L,C and Volume 
fro this into Metastock.

Now I need to automate this. What is the simpleast method?

I thought maybe writing Macros in Excel would work. Only I don't know 
that much about Macros. Can you help?

Thanks and regards

Rifki


> 
> > -----Original Message-----
> > From:	RIFKI@xxxxxxx [SMTP:RIFKI@xxxxxxx]
> > Sent:	Tuesday, July 01, 1997 3:50 AM
> > To:	metastock-list@xxxxxxxxxxxxx; eqsupport@xxxxxxxxx
> > Subject:	Converting traded stocks list to Excel
> > 
> > Hi ! Does any one know how I can get Excel to sort a list of stocks
> > traded for a 
> > day, like given below, into Open, High, Low, Close,Volume and 
> > therefore be able to convert to Metastock?
> > 
> > Here is the "trading list". Trades are entered as they happen. I need 
> > to sort these into Open, High, Low, Close,Volume otherwise I will 
> > have to enter into Metastock manually each day.
> > 
> > Thanks. And have a nice trading day !
> > 
> > Rifki
> > 
> >             100 ROYAL CERAMICS                  30.50
> > 
> >             100 ROYAL CERAMICS                  31.00
> > 
> >             400 ROYAL CERAMICS                  31.50
> > 
> >           2,400 ROYAL CERAMICS                  30.50
> > 
> >           2,300 ROYAL CERAMICS                  30.00
> > 
> >             600 ROYAL CERAMICS                  31.00
> > 
> >             400 ROYAL CERAMICS                  31.50
> > 
> >             300 ROYAL CERAMICS                  31.00
> > 
> >           1,000 SAMPATH 8/- PP                  75.00
> > 
> >           2,700 SAMPATH 8/- PP                  76.00
> > 
> >           1,200 SAMPATH 8/- PP                  75.00
> > 
> >             300 SAMPATH 8/- PP                  76.00
> > 
> >           3,600 SAMPATH 8/- PP                  75.00
> > 
> >           6,600 SAMPATH 8/- PP                  76.00
> > 
> >             300 SAMPATH 8/- PP                  75.00
> > 
> >             100 SAMPATH 8/- PP                  75.50
> > 
> >          13,500 SEYLAN BANK                     25.50
> > 
> >          21,000 SEYLAN BANK                     25.25
> > 
> >          11,500 SEYLAN MERCHANT                  5.00
> > 
> >             200 SHAW WALLACE                    25.00           
>