Excel vs Google Sheets Function Names
Key difference: Excel uses the DIVIDENDDATA. namespace (dot notation) while Google Sheets uses underscore notation.
Function Name Comparison
Google Sheets | Excel |
=DIVIDENDDATA("MSFT", ...) | =DIVIDENDDATA.DIVIDENDS("MSFT", ...) |
=DIVIDENDDATA_BATCH(...) | =DIVIDENDDATA.DIVIDENDS_BATCH(...) |
=DIVIDENDDATA_STATEMENT(...) | =DIVIDENDDATA.STATEMENT(...) |
=DIVIDENDDATA_METRICS(...) | =DIVIDENDDATA.METRICS(...) |
=DIVIDENDDATA_RATIOS(...) | =DIVIDENDDATA.RATIOS(...) |
=DIVIDENDDATA_GROWTH(...) | =DIVIDENDDATA.GROWTH(...) |
=DIVIDENDDATA_QUOTE(...) | =DIVIDENDDATA.QUOTE(...) |
=DIVIDENDDATA_QUOTE_BATCH(...) | =DIVIDENDDATA.QUOTE_BATCH(...) |
=DIVIDENDDATA_PROFILE(...) | =DIVIDENDDATA.PROFILE(...) |
=DIVIDENDDATA_FUND(...) | =DIVIDENDDATA.FUND(...) |
=DIVIDENDDATA_SEGMENTS(...) | =DIVIDENDDATA.SEGMENTS(...) |
=DIVIDENDDATA_KPIS(...) | =DIVIDENDDATA.KPIS(...) |
=DIVIDENDDATA_COMMODITIES(...) | =DIVIDENDDATA.COMMODITIES(...) |
=DIVIDENDDATA_CRYPTO(...) | =DIVIDENDDATA.CRYPTO(...) |
=DIVIDENDDATA_PRICE_TARGET(...) | =DIVIDENDDATA.PRICE_TARGET(...) |
=DIVIDENDDATA_ESTIMATES(...) | =DIVIDENDDATA.ESTIMATES(...) |
Same Parameters
All parameters work identically between platforms. The only difference is the function naming convention.
Need Help?
Help Center: help.dividenddata.com
Email: [email protected]
YouTube: @DividendData