I am making a program to compare stock prices. Unfortunately the free stock price server changes to position of the last prices when the market closes. When the market is open, I should vlookup column 2, but after closing time (8 pm or 20:00), Ishould vlookup column 4.
Any ideas how to solve this?
How to implement time checking to this formula:
VLOOKUP(A9;(VALUES!A$1:D$278);2;FALSE))
Any ideas how to solve this?
How to implement time checking to this formula:
VLOOKUP(A9;(VALUES!A$1:D$278);2;FALSE))