PureBytes Links
Trading Reference Links
|
Hi Christian
Thanks, but I want to do a little more than SORT the data from
Ascending to Descending or vice versa. The data has to be sorted into
O,H,L,C,V. My guess is this can be done with a few simple macros, but
I just don't know how to writhe them.
Thanks again
Rifki
> From: BAUDECB@xxxxxxxxxxxxx (Christian Baude)
> To: RIFKI@xxxxxxx
> Subject: Re: Converting traded stocks list to Excel
> Date: Wed, 02 Jul 1997 02:45:01 GMT
> On Tue, 1 Jul 1997 09:50:04 SLT0, you wrote:
>
> >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.
>
> Hi Rifki,
>
> The information you ask is very fundemental. Check your manual.
>
> 1st - I need to know the version number you're using. In any even, use
> the Help feature which should be available in all versions of Excel.
>
> Place the cursor on the column you want to sort, and click on the A/Z
> or Z/A icon.
>
> Read the Help file if you get undesired results, as I do not know how
> you configured your spreadsheet or Excel.
>
> -= Chris =-
>
|