Hi all
In excel, I’ve got constantly updating current stock prices that’s fed in through an API. In the adjacent cells I'm hoping to statically record the reported stock prices in every 5 minute intervals. Say at 3pm the price was $1 and at 3.05pm it was $1.2. Is there anyway I can do this? Either vba or formula will be good. It should be automated. Thanks!
