Forum Discussion
Solved
STOCK HISTORY HELP
I love the stock history spreadsheet. It is amazing for stock analysis at the beginning and end of each day. My question, to all of you smart folks out there is, is it possible to automate the process...
- VBA will definitely be the right move in this case then. If you look up a "for loop", you could have a list of tickers, and have VBA run through that list, checking for each ticker if your criteria is met and if yes > save a copy to another location.
Can't get into more specific details without seeing the workbook structure.
Hope this helps!
I switched from MS 365 Family to MS 365 personnel and the subscription expired yesterday. The switch was done immediately and as per MS Team the subscription is active though the next charge will be after sometime. All of a sudden from today the stock history is not working and it is showing sever error, the screen shot are attached above. Could anyone please suggest a solution.