We have 66 global stock exchanges and counting. For our full list please see Available Markets in our docs. Here's a list of a few of the main ones you may be interested in: NASDAQ, NYSE, LSE, HKG, NSE, EURONEXT, SIX, ASX, OSE, XETRA, MCX, TSX and FSX.

No. Your 15 day free trial begins when you install the Google Sheets extension! If you like what you see, sign up at any time from your account dashboard or from within Google Sheets by clicking 'Account' from the extensions drop down menu.

The financial world is full of metrics and ratios, e.g., EPS, EBIT, ROE, P/E, NOPLAT and so on... And whilst a company's reported figures don't vary too much from provider-to-provider these calculated metrics can. The way various providers such as Morningstar, Bloomberg or Yahoo choose to define these metrics can have an impact on the final number. Therefore, we've created a financial formulas page in our documentation which explains the way we define our calculated metrics. As always, if something doesn't stack up, please reach out and let us know.

Yes! We have a Template Library with a range of free templates that you can copy to your own Google Sheets account. These templates cover various use cases, from portfolio tracking to financial analysis. You can also create your own templates and share them with the community.

Nope! You have unlimited access to our data source. You may hit our rate limit if you attempt to pull a lot of data simultaneously, but one re-call and it will be right where you want it. It's important to note that Google imposes it's own daily quota of 20,000 external requests for a single, free Google account. This is a very large daily allowance, but if you intend to use SF heavily, you can increase this daily quota through upgrading your Google account. Read more about under limits and quotas in our detailed documentation.

We are constantly reviewing and improving our global data delivery network. We source our data through distribution agreements with a number of wholesale market data providers. In the case of US equities, the data is sourced directly from a secure connection to CTA and UTP Feed, and historical financials are collated from SEC filings.

The most common cause of a #REF! error is when your sheet doesn't have enough space to display the data returned by a SheetsFinance function. This can happen if you have a formula that returns an array of data, but the cells below it are not empty. To fix this, ensure that the cells below your formula are empty or adjust your formula to return a single value instead of an array.

Thanks for letting us know! Whilst we have a huge selection of financial assets, we may not have the one you're after yet. Just drop us a line in our contact page so we can get it for you and continue to improve the product!

This error can occur from time-to-time when you first copy a template from our Template Library to your account. This is due to the way Google Sheets handles caching for third-party extensions when copying templates that are running scripts. Don't panic, the issue resolves itself automatically after a short while, so just close the sheet and return to it later. You are still able to use SheetsFinance in any other spreadsheet you own.

Yes, you can connect your brokerage account to Google Sheets using our brokerage connections feature. This allows you to pull in your portfolio holdings, transactions, orders, balances, and options positions directly into your spreadsheet. SheetsFinance currently supports connections with major brokerages like Interactive Brokers, Robinhood, and Charles Schwab. Brokerage connections are available as a separate product to our data plans, which includes a 15-day free trial. You can find out more about brokerage connections on our brokerage documentation page.