IF statements with Dates

[Guest]

I'm trying to make a stock worksheet that gives me my stock data with a MS
Money web query. That works fine, what isn't working is, I have a worksheet
called "Daily stocks" with dates starting in A3 and starts with today’s date
(today’s date because I can't get my IF statement to work) and ends in 2009.
I also have my stocks starting in B1 and ending in P1.

Now to the problem

On my daily stocks sheet I want the stocks to post automatically in on the
date given and that works great. The stocks show up fine. The problem is,
when the date changes to the next day, (say, April 27th) the stock quots in
April 26 go blank or display’s a 0. How can I make it so when the date
changes the cells are left alone in the previous date cells?


This is my formula:

=IF(TODAY()=$A3,'Dons Stock'!$G$8,"")

I want to copy that formula (or one that works) into all the cells down to
2009. But I want the previous date stocks to be left alone when the date
changes to today, and the new stocks inserted for that day in that date. Any
ideas would be grateful.

Thanks.

 

[Fred Smith]

If seems to me you need to copy the data, rather than use an If statement. Why
not copy the data to the appropriate row where you are trying to store it?

 

[Guest]

Thanks for the response, but what I would like it to do is update on its own
on each date. Keep the old data in the previous date and add new data in
today's date. That way I can keep track of my daily stocks and make a graph
without having to on a webpage to check. And I also don't want to have to do
it manually. It’s a simple request but difficult to do.

 

[Fred Smith]

As powerful as Excel is, it isn't yet capable of 'updating on its own'.

When you're prepared to do some work, let us know. The solution won't be that
difficult. There have to be thousands of people who keep track of stocks on a
daily basis.

 

[Guest]

Wow, Fred, you win the “Most ineffectual replies of the year†award! I don’t
want excel to ‘update on its own,’ what I wanted was a formula to make it
update on its own. But thank you for nothing.

 

[Fred Smith]

Any time.

--
Regards,
Fred

Wow, Fred, you win the "Most ineffectual replies of the year" award! I don't
want excel to 'update on its own,' what I wanted was a formula to make it
update on its own. But thank you for nothing.