|
PureBytes Links
Trading Reference Links
|
Thanks Tom, this is VERY helpful.
Adam
----- Original Message -----
From: Tom Schaefges <tom@xxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Tuesday, February 08, 2000 7:20 AM
Subject: Re: Excel advise.....
> When I need the last value in a column I create two cells at the top of
the
> column. The first one (say A1) has a formula "=COUNTA(A3:A1000)" to count
> the number of cells in that column that have been filled in. The second
cell
> (A2) would find the last value in the column using the count from the
first
> cell by "=OFFSET(A3,A1-1,0)". These could be combined if you have no other
> need for the count.
>
> Tom Schaefges
>
>
>
> ----- Original Message -----
> From: Adam Hefner <vonhef@xxxxxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxx>
> Sent: Monday, February 07, 2000 10:29 PM
> Subject: Excel advise.....
>
>
> Hi guys,
> This is my first spreadsheet, so I need some help.
> Below is a picture of my program, I manually insert the highs,lows, and
> close for days 1-4 (white cells). It then gives me calculations for day 5
> (in gray cells). I have figured out how to import my ASCII text file into
> Excel but what do I need to do from there?
>
> 1. Since I will update the data each day, and the first row is the oldest
> date...
> how do I program excel to use the LAST entry of each column?
>
> 2. Should I add another sheet for each ASCII text I import, or is there a
> better/preferred method of managing the data?
>
> Thanks in advance,
>
> Adam Hefner
>
>
>
>
>
>
|