Forum Discussion
Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With ov...
Hi all
Not sure where to start a discussion, so replying to the welcome post here. 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!
- This is the best place to create the discussion. It's been linked a few times already in this thread.
https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneralThank you! Sorry for posting in the wrong place. Patrick2788
