Below is the test sheet.  All the basics work.  I would like this report to look up today , yesterday's stock price ( test was DMC ).  Currently, the logic works except the it is unable to pull in the price from the internet so it needs to be done manually.  My current formula is as below but it looks like google finance cannot pull in stock prices from this exchange.  

 

=INDEX(GOOGLEFINANCE(A1,"close",TODAY()-2,TODAY()-1),2,2)