After you have installed the add-on from the G Suite Marketplace, open an existing Google Sheet or create a new one. Then go to ADD-ONS > MARKETVIEW > FORMULA BUILDER to open the add-on sidebar and follow these steps:
In “Insert in Cell” input the cell reference (e.g. “B2”) of where you want to insert the data.
In “Ticker Symbol Cell” input the cell reference of where the corresponding ticker is located (e.g. “A2”).
Select then the Data Type you want to pull and the specific Data Attribute from the dropdown menus (e.g. “Real Time Data” and “Price”).
Once done, click on Create and in a few seconds you’ll see the data generated in the cell selected in step 1.
Marketview allows you to retrieve real-time data and historical data into your Sheets. We support US stocks, ETFs, and cryptocurrencies. For a complete overview and description of all data supported for each instrument, please see the USER MANUAL.
For a complete overview of all assets currently supported, please have a look at our TICKER DATABASE. Simply search by name or by ticker symbol to check if the securities you’re looking for are covered. Please note that we do our best to keep expanding our database by including new assets regularly, but if a ticker symbol you’re looking for is not present in the list, please drop us an email at firstname.lastname@example.org and, if data are available via API, we’ll include it right away.
All Marketview functions automatically refresh every 60 mins* after the very first opening of the Formula Builder, which activates the time trigger.
*Note: At every auto-update, Marketview will retrieve the real-time data of that precise time. Please note that the 60-minutes time trigger is a limitation imposed by Google on its add-ons. We guarantee that in case Google decides to lower or remove entirely that limitation, we will update Marketview accordingly to allow more frequent updates.
The data loading speed depends primarily on the number of Marketview functions you have created in your sheet. The more the functions, the bigger the volume of data called simultaneously and hence the longer time needed for loading.
However, if your functions appear to be stuck on “LOADING…” and won’t refresh even after a couple of minutes, this is most likely a cache issue that can be solved by manually refreshing the sheet/web page or, more rarely, by waiting for next hourly data refresh.
Not all data are available for all financial assets. For an overview of the compatibility between data attributes and instruments, please have a look at the COMPATIBILITY MATRIX. In case you are experiencing any malfunction and are unable to see data that should otherwise be available for your selected ticker symbol, please contact us at email@example.com and we will be happy to assist you in 24 hours or less.
We offer a 15-day trial to test all the features of Marketview. No credit card required, install the add on and enjoy it. After the free trial, upgrade to enjoy unlimited access to all real-time and historical data for as low as $2.99/month (Just $0.1 /day) for a year. You will be charged $35.88 for your yearly subscription which automatically renews at the end of the 12 months.
You can upgrade in three easy steps:
Open a Google Sheet
Select MARKETVIEW from the Add-ons menu
Click on UPGRADE TO PREMIUM and proceed to secure checkout via Stripe
You can purchase Marketview with any major credit card. All your sensitive data is stored securely, and payments are processed by Stripe.
Yes, we do. You can get 1 month for free by leaving us an awesome 5-stars review on our G Suite page. Once reviewed, notify us at firstname.lastname@example.org to get the free month. Please allow 24 hours to see the expiration date in your MY ACCOUNT menu extended.
It’s easy to cancel your subscription:
– To cancel a Premium subscription, send us an email with the text ”Cancel subscription” at least 48 hours before the end of the billing period. You can check the Expiration Date of your subscription right from the add-on by going to ADD-ONS > MARKETVIEW > MY ACCOUNT.
– To cancel a free trial, you have nothing to worry about. You will not be charged as you will be asked for your payment details only after the trial has expired.
We do not offer refunds as we offer you a 15-day trial to test all the features of Marketview for free before committing to a paid plan.
If you cancel your plan before the next renewal cycle, you will retain access to your account and all paid features until the end of the subscription period. When your subscription expires, you will lose access to paid features and all data associated with those features.