MicrosoftKayceeSue Thank you so much for your response. One of the things that I wanted to check, but couldn't find further information to, is how are stock splits (reverse splits) handled by this function? For eg: Let's assume Amazon stock is currently at $2,500 and they decide to do 5 for 1 stock split. The share price would fall to $500 (and would perhaps settle a little over it reflecting wider market participation at lower price hence pushing the share price up). What would the output look like using #Stockhistory? Would it index the price and volume prior to the split?
Next, ex-dividend date - any possibility of showing that through the function? This is when share price typically falls to reflect the dividend cash outflow.
My third suggestion is the same as ExcelExciting - to have string values for properties to make the function more user friendly during audits.
