DataSetIQ Plugins Support

❌ "Unknown function: 'DSIQ_LATEST'"

Cause: Plugin not loaded or functions not recognized

Solutions:

• Google Sheets: Close and reopen the sheet completely (close browser tab)
• Excel: Close and reopen Excel, then reload the add-in
• Ensure the plugin is installed and authorized
• Wait 10-15 seconds after opening for functions to load

❌ "Series not found" or 404 Error

Cause: Invalid series ID or series doesn't exist

Solutions:

• Verify the series ID format (should be "SOURCE/SERIES_CODE")
• Use the Search or Browse tab to find the correct series ID
• Check for typos in the series ID
• Some series may require full data ingestion (click "Fetch Full Dataset" in preview)

❌ "Invalid API key" or Authentication Error

Cause: API key is incorrect, expired, or revoked

Solutions:

• Go to datasetiq.com/dashboard/api-keys
• Create a new API key
• Copy and paste it into the plugin (don't type manually)
• Make sure there are no extra spaces before/after the key

❌ "Free tier limited to 100 observations"

Cause: Using plugin without API key

Solutions:

• Connect your API key for 1,000 observations per series
• Upgrade to a paid plan at datasetiq.com/pricing
• For free users: The 100 most recent observations are sufficient for most analysis

❌ Sidebar Won't Open (Google Sheets)

Cause: Permission issues or authorization needed

Solutions:

• Click DataSetIQ → Authorize first
• Review and grant all requested permissions
• Then try DataSetIQ → Open Sidebar
• If still failing, try removing and reinstalling the add-on

❌ Slow Performance or Timeouts

Cause: Too many simultaneous requests or network issues

Solutions:

• Avoid inserting dozens of formulas simultaneously
• Use DSIQ_LATEST instead of full DSIQ arrays when possible (faster)
• Check your internet connection
• Wait a few seconds between large operations
• Our API has rate limiting for fair usage

❌ Premium Features Locked

Cause: Not using a valid API key with premium subscription

Solutions:

• Ensure your API key is connected (see status at top of sidebar)
• Verify your subscription is active at datasetiq.com/dashboard/billing
• Free users see 🔒 icons on Builder and Templates tabs - this is expected

Can I share spreadsheets with DataSetIQ formulas?

Yes! You can share your spreadsheets with others. However, they will need their own API key to refresh the data. The formulas themselves will remain in the cells.

Do formulas auto-refresh?

Formulas recalculate when you open the spreadsheet or manually trigger recalculation. They don't auto-refresh on a schedule. For real-time monitoring, consider using our web dashboard.

Which platforms are supported?

Excel:

• Excel 2016 or later (Windows/Mac)
• Excel Online (web)
• Excel on iPad

Google Sheets:

• Web version (all browsers)
• Mobile apps (limited - custom functions work, sidebar may not)

Is my data secure?

Yes. Your API key is stored locally in your spreadsheet, not on our servers. All API requests use HTTPS encryption. See our Privacy Policy for details.

How much does it cost?

The plugins are free to use with limited functionality (100 observations per series). Premium features and increased limits are available with a paid DataSetIQ subscription. See pricing details.

Where does the data come from?

Data is sourced from authoritative government agencies and international organizations including FRED, BLS, BEA, Census Bureau, IMF, OECD, World Bank, ECB, Eurostat, and many more.