The code isn’t broken. The error you’re getting can mean one of 4 things:

1/ you did not save the .csv files you downloaded with TICKER.csv in ALLCAPS (replace TICKER with your desired symbols)

2/ your list of ticker symbols in the Controls worksheet are not in ALLCAPS

3/ you did not create a worksheet in your DATA.xlsm workbook named AC, DF, etc.

4/ you did not enter your ticker symbols in the DATA.xlsm worksheets as instructed or forgot to enter them in ALLCAPS. For example, you may have forgot to enter YHOO or entered it as yhoo.

Check the steps above and make sure you’ve done these steps correctly.

Did you find this useful? If so please share!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •