View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
edgarc edgarc is offline
external usenet poster
 
Posts: 1
Default formula for stock quote

I want to have my stock quotes updated to show the highest price th
stock has reached. I input the daily stock price in column A and I wan
that checked against column B which shows the highest past price. I
the new input in column A is higher, I want that column B change
automatically to reflect the new higher price. If the input price i
column A is not higher, I want column B to remain the same, reflectin
the older and higher price.
Everything I've tried on my own results in a circular error, even whe
I change the number of iterations and their parameters.
Answer to please
Thanks to any in advance
Edgar Couda

--
Message posted from
http://www.ExcelForum.com