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.
Fiche mise à jour le :14 mai 2024
Compatible avec :
10 k+
Présentation
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/
Informations supplémentaires
TarifsNon disponible
Développeur
Non-professionnel
Règles de confidentialité
Conditions d'utilisation
Market Data vous demandera les autorisations ci-dessous. En savoir plus
Market Data aura besoin d'accéder à votre compte Google
Market Data pourra ainsi effectuer les actions suivantes :
Consulter, modifier, créer et supprimer toutes vos feuilles de calcul Google Sheets
Afficher et diffuser du contenu Web tiers dans les invites et les barres latérales au sein des applications Google
Vous connecter à un service externe
Afficher l'adresse e-mail principale associée à votre compte Google
Consulter vos informations personnelles, y compris celles que vous avez choisi de rendre disponibles publiquement
Loading
Recherche
Effacer la recherche
Fermer le champ de recherche
Applications Google
Menu principal