Supported connection

Sync Fidelity to Google Sheets

Connect Fidelity through Plaid and the positions Fidelity reports for the accounts you connect land in one Holdings tab, with a Gain / Loss column Finta adds when it creates the tab.

7-day free trial. No credit card required.

Fidelity connects through Finta to Google Sheets

Fidelity

Finta

Google Sheets

Region
United States
Connection
Plaid
Sync timing
Varies by connection

Available data

What Fidelity data you can sync to Google Sheets

Finta can sync the kinds of data below. What you get depends on the accounts you connect.

Transactions
Sort, filter, categorize, and use transactions in the destination you choose.
Investments
Use holdings and investment activity when the connected account provides them.
Liabilities
Keep supported credit card and loan data next to the rest of your finances.

In Google Sheets

Your Fidelity data in a spreadsheet

Finta adds your Fidelity data to a Google Sheet and keeps it current. Depending on the accounts you connect, the sheet can include Accounts, Transactions, Balance History, Securities, Holdings, and Investment Transactions. Use the records in your own formulas, filters, and reports.

Google Sheets integration

Holdings and trades

Your Fidelity portfolio, column by column

Quantity, every trade, and cost basis (when Fidelity reports it) come from Fidelity. Finta adds Symbol, Security Close Price, Total Value, and Gain / Loss as formulas when it creates the Holdings tab, so you can see them, change them, or build on them.

Holdings tab

Sample data

SymbolSecurity TypeQuantityCost BasisSecurity Close PriceTotal ValueGain / Loss
VTIetf429,450.00298.1212,521.0432.50%
AAPLequity152,610.00231.403,471.0032.99%
BNDetf604,620.0073.854,431.00-4.09%

Investment Transactions tab

Sample data

DateSymbolTransaction TypeTransaction SubtypeQuantityPrice
2026-10-03AAPLsellsell-5228.75
2026-09-30BNDbuydividend reinvestment0.2173.40
2026-09-15VTIbuybuy2291.10

The data is fictional and shows a few of each tab's columns. Total Value is Security Close Price times Quantity, and Gain / Loss is a percent: Total Value divided by Cost Basis, minus 1. Close prices are the last market close, so Total Value can differ from what Fidelity shows during trading hours.

Holdings
Account, Symbol, Security Name, Quantity, Cost Basis, Base Currency, and Last Update, plus Security Close Price, Security Type, Total Value, and Gain / Loss as a percent. One row per position in each account.
Securities
Symbol, name, security type, and the last close price with its date. Option details are optional fields. To get them, open the Securities table settings in Finta and use Add Field to add Option Contract Type, Option Expiration Date, Option Strike Price, and Option Underlying Ticker. They fill in when Fidelity reports the contract.
Investment Transactions
Date, security, quantity, price, amount, fees, and currency for each buy, sell, dividend, fee, and transfer. The subtype tells a dividend from a dividend reinvestment, a contribution, or an interest payment.

Keep a history, not just today's positions

Finta keeps one Holdings row per position and updates it in place. Sell a position and its row stays, with Quantity set to 0, as long as the account still holds something. If you sell everything in an account, its old rows keep their last values, and Last Update shows when each one last synced.

For value over time, add Balance History. Finta stores each account's balance once a day and adds a dated row, so you build a daily record of what each Fidelity account was worth.

Want position-level snapshots too? At month end, copy the Holdings tab and paste its values into a new tab named for the date.

Setup

Three steps to connect Fidelity to Google Sheets

  1. 1

    Connect your Fidelity account in Finta.

  2. 2

    Choose what to sync.

  3. 3

    Connect Google Sheets and pick the sheet.

Timing and limits

Sync timing varies by connection and destination

Your source connection decides when new data is available. Finta syncs supported updates according to the source connection and Google Sheets behavior.

Source and destination permissions

Plaid handles sign-in, so Finta doesn’t receive or store your Fidelity password. The financial connection is read-only. Finta cannot move money. Writing into your Google Sheet is a separate permission you give Google Sheets.

Fidelity to Google Sheets questions

Can I connect Fidelity to Google Sheets automatically?
Yes. Connect your Fidelity accounts, choose Holdings and Investment Transactions, and Finta keeps them current in your sheet. Sync timing varies by connection.
Do all my Fidelity accounts go into the same sheet?
Yes. Holdings from every Fidelity account you connect share one Holdings tab, and the Account column tells them apart. Workplace plans on NetBenefits connect separately as Fidelity NetBenefits.
Does Fidelity cost basis sync to Google Sheets?
Yes, when Fidelity reports it. Finta writes each position's total cost basis to the Cost Basis column. If Fidelity doesn't report one for a position, that cell stays empty and so does its Gain / Loss.
Can I track Fidelity options in Google Sheets?
Option positions sync as holdings. The contract details are optional Securities fields, so add them first. Open the Securities table settings in Finta and use Add Field to add Option Contract Type, Option Expiration Date, Option Strike Price, and Option Underlying Ticker. Those fields fill in when Fidelity reports the contract.
Does crypto show up?
Only crypto that Fidelity reports as a holding. Finta sets its security type to cryptocurrency. Coins you hold at a separate exchange aren't part of this connection.
Can Finta move money from Fidelity?
No. Finta cannot move money through the financial connection.
Supported connection

Put your Fidelity data to work in Google Sheets

7-day free trial. No credit card required.

Search Finta

Navigate to important pages