Closed ClimberMel closed 1 year ago
I updated you with your latest as of today. No compile problems. However, I still cannot sum the dividends for a stock.
The below formula I used until December 2022 to sum the dividends for the trailing 12 months. G10 is the ticker, I used MSFT.
=SUM(INDEX(RCHGetYahooHistory(G10,YEAR($A$2),MONTH($A$2),DAY($A$2),YEAR($A$1),MONTH($A$1),DAY($A$1),"v",,,,,99,2),,2))
You can see that it is getting the information, but it is not summing.
I updated you with your latest as of today. No compile problems. However, I still cannot sum the dividends for a stock.
The below formula I used until December 2022 to sum the dividends for the trailing 12 months. G10 is the ticker, I used MSFT.
=SUM(INDEX(RCHGetYahooHistory(G10,YEAR($A$2),MONTH($A$2),DAY($A$2),YEAR($A$1),MONTH($A$1),DAY($A$1),"v",,,,,99,2),,2))
You can see that it is getting the information, but it is not summing.