Forum Discussion
STOCK HISTORY FUNCTION OPEN PRICE FOR ONE DATE IN ONE CELL ONLY
The date 5 years ago could be not trading date. For such dates stock prices are not published, you need to take latest previous trading date. Using STOCKHISTORY that could be
=TAKE( STOCKHISTORY("MSFT", EDATE(TODAY(),-12*5)-10, EDATE(TODAY(),-12*5),0,0,1), -1)which returns one-cell value for the closest trading date 5 years ago.
Microsoft Excel is not specialized software to work with market prices. It gives some basics and lot of other functions around. Combining them you could receive desired result.
Instead of hardcoding date, close or open price, etc., you may write your own function to parametrise about depends on your own needs.
The date 5 years ago could be not trading date. For such dates stock prices are not published, you need to take latest previous trading date. Using STOCKHISTORY that could be
=TAKE( STOCKHISTORY("MSFT", EDATE(TODAY(),-12*5)-10, EDATE(TODAY(),-12*5),0,0,1), -1)which returns one-cell value for the closest trading date 5 years ago.
Microsoft Excel is not specialized software to work with market prices. It gives some basics and lot of other functions around. Combining them you could receive desired result.
Instead of hardcoding date, close or open price, etc., you may write your own function to parametrise about depends on your own needs.
OK THANKS.
IT WORKS BUT WILL YOU PLEASE SHOW ME HOW FOR 500 STOCKS I WATCH ?
I CAN GET IT TO WORK BUT I'D HAVE TO TYPE IN ALL OF THEM MANUALLY.
HERE IS A FILE WITH THE EXAMPLE