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 want to know more about this investment strategy haha. But couldn't you just run STOCKHISTORY off a list of tickers? One cell for one ticker doesn't sound too efficient. Depends on how your spreadsheet is set up.
- I would love to do that but the way my sheet is set up I use 6 months of previous history to find those green lights. So a sheet contains 5000 tickers, each with 6 months of data, would be MASSIVE.
- 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!- Thank you so much! I would gladly share this info with you but I would need to contact you personally. I can't seem to figure out how to do that either.
