Update of stock price information -- only if higher

[John stieven]

Quick question -- each day I get a list of 250 stocks with their current prices. These then reside on a worksheet.

The next day, I repeat the process. With this new data, what I wish to do is to update "only" those prices for those stocks that have risen and leave prices that have dropped alone.

How can I do this?

 

[vletm]

@John stieven
Without sample file, this would be this kind:
Save new data somewhere known place.
Compare new and old values one-by-one and
if new value is bigger then use new value.

 

[John stieven]

Vietm -- what I want it to then do if it sees the Higher Value is to update the table -- ready for tomorrow's inputs

 

[vletm]

@John stieven
Did You read my previous reply?
ReRead again, especially the 1st line.
Or are You ready to change everything?

 

[John stieven]

I do not understand -- apologize ...

So the "new file" comes in every day. The "data list price" is the price of the security in the file. What I then want is the "Data List Price" to automatically update if the current day price is higher, and do nothing if lower. I will then save the file, and get ready for tomorrow.

I know it will require a VLOOKUP (as the security listings do not come in the same order every day) -- it is the 'lookup and replace" function I have no idea about.

Does this make sense?

 

[vletm]

@John stieven
There need to be TWO files;
OLD and that NEW informations.
Without those informations ...
it would be challenge to compare which would be bigger.
That 'chandoo.slsx' has header 'New daily file'.
Where is 'old' list?

 

[John stieven]

the "old" pricing file is the "Data Price List" column

 

[vletm]

You wrote:
each day I get a list of 250 stocks with their current prices
Do You mean those 'calculated' values '=C+D' ?
It would be much 'normal' to compare 'old' and 'new' values!
Where comes that D-column value? hmm...?

>> TWO lists, OLD and that NEW-file.

 

[John stieven]

Column "D" is just a "Made Up" factor for this example that allowed me to print column E prices different from column C. Think of "C" as NEW; "E" as OLD prices (in the 'real' file column D does not exist)

 

[vletm]

As I wrote ... try to wrote ...
It would be much 'normal' to compare 'old' and 'new' values!

Here is one part of Your 'Think'-list! Few doubles ...!
For me, 'old' and 'new' list.
I would check next time about 12hrs later.