Market Data - Google Workspace Marketplace

Current and historical options prices. 15+ years of data. Bid, ask, volume, open interest, and more. Market Data’s free Sheets Add-on is the perfect companion for options traders.

By:

Listing updated:December 19, 2024

Works with:

11K+

Overview

Finally, a simple function to get options data in Google Sheets that works exactly like GoogleFinance. It's as easy as =OPTIONDATA("AAPL230120C00150000") to get a current options price into your spreadsheet. Both current and historical data (15+ years) are supported.

Get started 100% free, no credit card required.

CURRENT DATA
Get a current options price with one simple formula, exactly as you would with Google Finance.
Your spreadsheet will update automatically as new prices become available.
Perfect for tracking your ongoing options trades.
Get bid, ask, or midpoint prices individually or download all data about any currently trading options contract directly into your spreadsheet, all updated automatically ask the market moves.

HISTORICAL DATA
Backtest your options strategies with historical options prices.
15+ years of pricing data for standard options.
5000+ optionable tickers are supported.
All data provided by MarketData.app

FREE ACCESS TOKEN
Visit https://www.marketdata.app for a free access token.

Market Data (this add-on) and its authors are not responsible for any trading loss incurred through the use of this add-on or our data. The service is provided "as is", without warranty of any kind, expressed or implied, including fitness for a particular purpose. Full terms and conditions of use are available at https://www.marketdata.app/terms/

Additional information

PricingNot available

Developer

Non-trader

Support

ReportFlag as inappropriate

Reviews

Language:

Sort by:

Google doesn't verify reviews or ratings. Learn more about reviews

Kent Biswanger

August 29, 2024

I have been building a custom indicator for the past several months and have tested a bunch of different data sources but struggled to get consistent results. In searching for a company that provided a data API that would service my needs I ran into many issues from unreliability to excessive cost that made them an unsustainable option. In my search I stumbled across Market Data App, my expectations weren't very high because of my previous experience and the fact they are a very new company. Boy was I wrong, these guys have been great and their solution is exactly what I needed not to mention at a price that makes sense and an upgrade path as my needs expand. 10/10 I will recommend this company to anyone with the need.

Is this review helpful?

Yes

Matt Pope

August 20, 2024

I find this a very useful service. It does everything that I need it to do. It is easy to interface with. I like the help desk. They are easy to interact with and very quick to reply. I use the service daily and find it has a great server uptime, I have never had an issue with the server being down and it is very fast interacting with my calls. The api interacts easily with your own software as well as google. It is very reasonably priced. They are adding new feeds all the time and users can request new items to be added. I like the fact it is growing and taking input from grass root users to grow in a way that suits the people using it rather than just giving a here it is attitude. I've used it for close to 12 months now so I believe I have given it a fairly good run. I think it is definitely worth a look at it you are look for stock market data that is easily accessible with good support.

Is this review helpful?

Yes

Ronn Brashear

June 25, 2024

Think of this company like a start up - they are scrappy and get things done. The product is simple, flexible, and just plain works. Yes, there has been a bug or two, but the team closed the major one within 36 hours so no complaints. The minor one persists for now and I bet it will be closed within a sprint or two. I wouldn't trust it enough to write a trading automation. However, for easy analysis and journaling, it's great. Highly recommended. And yep, I bought the pro because I was able to make a GSheet trading journal where I can dump trade logs from my brokerages as well as the current holdings and create great analyses far cheaper than the paid sites.

Is this review helpful?

Yes

James Michael Mannion

February 29, 2024

After trialing the free version for retrieving basic pricing on individual options and finding it works at least as well as my own functions did before Y! locked down their query2 API, I will say that it was easy to install and provided the basic function. I would like to upgrade so that I'm not limited in number of quotes, but I feel it's a bit pricey if I'm only using it for options prices, especially considering there will very likely be competitors soon (imagine it built into Sheets or offered as a feature from your favorite brokerage). And, I would DEFINATELY need it to stop returning #ERROR! after market close (just return the closing values and don't expect to be paid for free data) so that I can do my planning for the next market open. I understand why some are making it difficult to lock down even the delayed quote data, and this is a good alternative to roll-your-own. I'll look forward to fairer pricing and fixes to a few glitches. HTH.

Is this review helpful?

Yes

David Trujillo

October 9, 2024

Excellent for Option Data.

Is this review helpful?

Yes

Max

August 22, 2023

Tried the free version which needless to say was missing a lot of features. Exchanged notes with the team who said they would implement some important upgrades if I got the lower tier paid version. I did just that - followed up on feature implementation - they then tried to backtrack and get me to get the higher tier paid version before implementing any changes I brought up the previous agreement and the team (likely the founder) then tried to gaslight me into thinking I was confused about the original exchange Bad guys / disingenuous - would not recommend

Is this review helpful?

Yes

Ed Coad

April 16, 2024

needed option data, has option data, easy to install and run. happy days.

Is this review helpful?

Yes

Gary Braver

March 30, 2023

Had very high hopes for this and as a computer guy didn't have much problems getting it to run. Don;t think this would be the case if you are not a techie as a lot of stumbling blocks to get this to work. My goal was to get option pricing for the google sheets doc. marketdata did provide this but totally inaccurate. Tesla is one of the most actively traded options. Fidelity and Robinhood had accurate real time prices for the options. Totally disappointed that marketdata provided grossly inaccurate info

Is this review helpful?

Yes

Sean Hogan

August 26, 2023

I have been using Market Data for a week and so far it's been great. I have a Google Sheet which needs to update around 80-120 cells several times a day with option pricing and delta values. This saves me a lot of time. The Google Sheet app on my iOS devices do not have the ability to open an add-on so I cannot tell the sheet on my iPhone to update the values as I can when I am on my laptop. Market Data provided a workaround so now Google Sheets on my iPhone will update the values and I can easily see the value of my positions.

Is this review helpful?

Yes

frans akkermans

September 11, 2023

I am a new user, used it so far only a few hours. It works very easy and so far so good. I am using it for an option spreadsheet. Zero complains at this moment.

Is this review helpful?

Yes

1-10 of 22

Clear search

Close search

Google apps

Main menu