sorry i may have got the wording wrong (im a beginner) but im looking for help with this one function i need for a school project on historical stock prices in excel.....basically i need a way to perform this function:
in row 1, i have 30 RANDOM historical dates, starting in B1 and going right
in column A, i have 10 stock symbols, starting in A2 and going down
Is there a way to automatically grab the ADJUSTED CLOSING PRICE for each symbol for each corresponding date?? if not i have to do it manually!!
Your help in this matter is much appreciated!!!!