Exporting Portfolio Data from Fidelity for Analysis (2024)

Fidelity does not currently have an API for retrieving portfolio data. Using Selenium, data pulls can be automated independently.

Many American’s use Fidelity’s brokerage services for their independent investing accounts, 401Ks, and Roth IRAs. Fidelity has some great visualization tools built into their platform but does not have any user-friendly external connections customizable to their clients, although you can download your portfolio as a CSV in a non-automated fashion. Some websites such as Yahoo Finance allow users to connect their accounts to visualize their current portfolio holdings, but even then the dashboarding capabilities are limited by Yahoo’s platform, and some services are even blocked behind a paywall.

A do-it-yourself alternative to get up-to-date portfolio holding daily is to use Selenium and a script written in a language such as Python to automate downloading data. Then, users can either open the content within Excel or take advantage of the many open source libraries available in Python for tracking asset fundamentals or leveraging advanced technical analysis.

Within the scope of this article, we will go over how Selenium scripts are recorded, how to implement that code within a Python script, and how to export a downloaded portfolio to a Pandas data frame within Python.

As background on Selenium, this software is freely available for user interface testing. During the software development lifecycle, the best websites and services are robustly tested to handle a variety of inputs and correct mistakes as they are encountered. Selenium is a tool for automating that process. Testing and completing lengthy forms or website practices for example take one user hours due to all of the repetitive keystrokes and mouse clicks, but a robot running on a server mere moments. For our case, we will be running one of these tests only once; we will be opening a new window, logging into Fidelity, navigating to our portfolio holdings, interacting with a button to download a copy of our portfolio, and logging out and closing the window. As a bonus at the end, I am also including additional elements to our script to move the copied file to a location other than our downloads folder (the default location), and how to open the content as a Pandas data frame for further analysis.

The first step complete to develop our testing script was to install the Selenium IDE as an extension for our web browser, in my case Chrome. A series of drivers will also be needed, with installation instructions found here.

Once Selenium is installed, the script can be recorded from the extension and is as simple as recording a macro within Excel.

We create a new project name, enter the Fidelity log-in page as our base URL, and then simply navigate to our portfolio, click the download link, log out, and close the window. Performing these tasks on our own is easy, and fortunately, the IDE handles the hard work of writing the code for us. To get our Python scripts out of the IDE and into a file users should right-click on the test name seen above (Untitled* in the photo), and export as a Python pytest. This process could be repeated with any other brokerage or site as well if there are similar operations that can be repeated.

A lot of the code provided by the IDE will not be used. For simplicity’s sake below is the working code that can be used to routinely perform these tasks.

import pytest
import json
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.action_chains import ActionChains
from selenium.webdriver.support import expected_conditions
from selenium.webdriver.support.wait import WebDriverWait
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.common.desired_capabilities import DesiredCapabilities
import time#Configure and launch driver for selenium data pull from Fidelity
driver = webdriver.Chrome()
vars = <>
driver.get("https://www.fidelity.com/")
driver.set_window_size(1587, 942)
driver.find_element(By.ID, "userId-input").click()
driver.find_element(By.ID, "userId-input").send_keys("USERNAME")
driver.find_element(By.ID, "password").send_keys("PASSWORD")
driver.find_element(By.ID, "fs-login-button").click()
#Wait for enough time to web page to render
time.sleep(5)
driver.find_element(By.ID, "tab-2").click()
#Wait for enough time to web page to render
time.sleep(5)
driver.find_element(By.CSS_SELECTOR, ".posweb-grid_top-download-button").click()
#Wait for enough time to web page to render
time.sleep(5)
driver.find_element(By.CSS_SELECTOR, ".pntlt > .pnlogin > .pnls > a").click()
driver.quit()

Note that we also imported the Python time library. Our new script may execute so quickly some components may not have loaded in depending on internet download speeds. The sleep values can be modified as needed, and if using this code don’t forget to enter your USERNAME and PASSWORD!

Now you have a newly downloaded copy of your portfolio in your downloads folder. What’s next? The choice is yours.

Below is another snippet of code for moving your CSV to a different folder, and opening it as a Pandas data frame. From there, the data can be manipulated up to your preferences. Another great library available for use is yfinance and integrating it will allow you to investigate a plethora of information about each of your assets.

import shutil
from datetime import date#Get todays date to add to the path
today = date.today()
todayDateString = today.strftime("%b-%d-%Y")
path = "Portfolio_Positions_" + todayDateString + ".csv"
oPath = "/Users/USER/Downloads/" + path
dPath = "/Users/USER/Documents/YOURFOLDER/" + path
shutil.move(oPath,dPath)import pandas as pd
df = pd.read_csv(dPath)
#Drop the last 3 rows which are disclaimers
df.drop(df.tail(3).index,inplace=True)

You now have a data frame with all of your asset data from Fidelity. Please feel free to check out my other articles on how to manipulate this data, and use it in analysis!

DISCLAIMER — This is not financial advice nor am I a financial professional. Please be responsible when making financial decisions.

How do I export my Fidelity portfolio? ›

By selecting the Download button on the History page, you can export data from your Account History on Fidelity.com directly into Microsoft Excel ® in CSV (comma-separated values) format. This will export your account transaction details.

Fidelity's Portfolio Analysis tool categorizes your investments to give you a better understanding of your portfolio's diversification.

1. Step 1: Sign up for a free Docparser account.
2. Step 2: Select the Bank Statements Parser. .
3. Step 3: Import a Fidelity Investments Bank Statement. .
4. Step 4: Create Parsing Rules. .
5. Step 5: Check the accuracy of the parsed data.

Currently there is no official API for Fidelity, you can try to export data from the website and load it into excel.

1. Log on to your Fidelity Investments account.
2. Select your account and click Activity & Orders followed by History.
3. Select a Time Period and click the Go button. .
4. Wait for the data to be displayed, then click the Download link to begin the csv file download.

1. From "Accounts & Trade" menu, select "Tax Information"
2. Under 'Tax Forms", click the "View your tax form" link.
3. In "Other Formats & Info" column, click on "CSV Format”
4. Save the file to your desktop or other folder on your computer.

Timely insights from Fidelity's portfolio managers and analysts on navigating volatility and long-term investing.

The GRESB Portfolio Analysis Tool lets you examine the performance of your aggregate portfolio against self-selected benchmarks in order to gain valuable insight into your investments, strategy, and overall ESG performance.

When can you withdraw from Fidelity without penalty? Starting at age 59, you can take withdrawals without penalties, though note that taxes may be due based on the type of IRA. You are not required to take withdrawals from any accounts before age 72. Your withdrawals should factor into your overall retirement strategy.

TurboTax allows you to import your Fidelity account's transaction information into its tax prep platform. Of course, you'll need your Fidelity username and password to get started. Fidelity is one of the big three brokerages, along with Vanguard and Schwab.

What is Fidelity for data collection? ›

Fidelity refers to implementing a program or curriculum as intended, which can be a key factor in its success and whether it positively moves youth outcomes. Fidelity monitoring refers to a system of measuring and analyzing the degree to which a program is implemented as intended.

Active Trader Pro is Fidelity's customizable trading platform for your desktop, optimized for today's technology.

1. In Microsoft Excel, select the File tab, then go to Options > Customize Ribbon.
2. In the Customize the Ribbon drop-down menu select Main Tabs.
3. Select the Developer check box then OK to apply.

Import the Fidelity data to Google Sheets

Open Google Sheets and launch Amigo Data from the sheet into which you want to extract the Fidelity Investments data. To connect to Amigo Data, click Extensions→Amigo Data→Connect. You'll be presented with a list of sources to connect to.

Go to File > Save As. Click Browse. In the Save As dialog box, under Save as type box, choose the text file format for the worksheet; for example, click Text (Tab delimited) or CSV (Comma delimited). Note: The different formats support different feature sets.

1. Go to the github repository link where you have the CSV file.
2. Click on the raw option present on the top right of the data.
3. This will open a new window in the browser.
4. You have to use this link to download csv file from the Github.

A CSV (comma-separated values) file is a text file that has a specific format which allows data to be saved in a table structured format.

1. Open Excel.
2. Click New, then click on Blank workbook.
3. Click on the Data tab.
4. Click Get External Data From Text.
5. Navigate to the CSV-formatted file saved on your system, select it, then click Import (When browsing to find the file, set browser to look for All Files or for Text Files)

To view and save the PDF version of a statement, tax form, trade confirmation, or account record, click the PDF link associated with the document. Then click the Save icon in the browser window's PDF toolbar, or select Save from the browser's File menu.

In almost any text editor or spreadsheet program, just choose File > Open and select the CSV file. For most people, it is best to use a spreadsheet program. Spreadsheet programs display the data in a way that is easier to read and work with than a text editor.

How do I analyze my portfolio? ›

Once a portfolio is in place, it's important to monitor the investment and ideally reassess goals annually, making changes as needed.

1. Step 1: Assess the Current Situation. .
2. Step 2: Establish Investment Objectives. .
3. Step 3: Determine Asset Allocation. .
4. Step 4: Select Investment Options. .
5. Step 5: Monitor, Measure, and Rebalance.

The BCG Matrix is one of the most popular portfolio analysis methods. It classifies a firm's product and/or services into a two-by-two matrix.

It requires no minimum investment amount and offers fee-free investment management for accounts worth less than $10,000. The investment management fee is $3 per month for accounts with balances between $10,000 and $49,999.

1. Joel Tillinghast. Joel Tillinghast joined Fidelity as an equities analyst in 1986, having previously worked at Bank of America, Drexel Burnham Lambert and Value Line Investment Survey. .
2. Will Danoff. .
3. Sonu Kalra. .
4. John Roth.

Morningstar has named Fidelity portfolio manager Joel Tillinghast as its Outstanding Portfolio Manager of 2021. Tillinghast, who holds an A rating with Citywire, beat out three other nominees for the top prize: JP Morgan's Jeffrey Geller, BlackRock's Rick Rieder, and Baird's Mary Ellen Stanek.

• Supporting Portfolios. .
• Key Operational Portfolios. .
• High Potential Portfolios. .
• Strategic Portfolios. .
• Implementing Strategic Portfolio Management.

There are three key criteria to take into consideration when assessing a portfolio: the combined value of the projects in the portfolio, the overall risk/value balance, and the alignment of the portfolio with the strategic goals of your business.

• Project Planning.
• Resource Management.
• Budget Management.

Fidelity: 2023 Comparison. Vanguard and Fidelity are both retirement powerhouses, but Fidelity offers a more well-rounded platform that also caters to active traders.

Start saving now with a no monthly fee savings account for younger customers. The $2.00 fee for additional withdrawals can be avoided by maintaining a minimum daily collected balance of $2,500.

Is there a penalty for withdrawing from Fidelity? ›

A higher 25% penalty may apply if you take a withdrawal from your SIMPLE within 2 years of your first contribution. You may be able to avoid the 10% and 25% tax penalties if your withdrawal falls under certain exceptions. The most common exceptions are: A first-time home purchase (up to $10,000)

Use H&R Block to prepare your taxes online and save time by seamlessly importing information directly from your Fidelity accounts. File by yourself from any device, anytime, with expert help if needed.

Year-end fund distributions apply to all shareholders equally, so if you buy shares in a fund just before the distribution occurs, you'll have to pay tax on any gains incurred from shares throughout the entire year, well before you owned the shares.

Gains from the sale of securities are generally taxable in the year of the sale, unless your investment is in a tax-advantaged account, such as an IRA, 401(k), or 529 plan. Generally, for those accounts, you only incur taxes when you start taking withdrawals.

Gross advisory fee applicable to accounts managed through Fidelity ® Strategic Disciplines ranges from 0.20% to 0.49% and gross advisory fee applicable to accounts managed through Fidelity ® Wealth Services ranges from 0.50%–1.04%, in each case based on a minimum investment of $2 million.

Users also have free access to both Fidelity research and third-party research from more than 25 sources, including Zacks Investment Research, Standard & Poors, and Moody's Investor Service, Inc.

Amazon and Fidelity Investments are not affiliated. Amazon and the Amazon logo are trademarks of Amazon.com, Inc or its affiliates.

Fidelity's site is best viewed with the following browsers and plug-ins: Microsoft ® Internet Explorer. Firefox. Safari.

Active Trader Pro ® is just one of Fidelity's Decision Tech tools that can help you make smarter decisions before, during, and after the trade.

Is Excel API free? ›

Are there examples of free Excel APIs? Not only are there dozens of free Excel APIs available from sites like RapidAPI, Microsoft has a large library of APIs for use with its software, which includes not only Excel but Microsoft Graphs and Visual Basic as well.

API stands for Application Programming Interface. In the context of APIs, the word Application refers to any software with a distinct function. Interface can be thought of as a contract of service between two applications.

1. Configure the API endpoint. An API endpoint can be complex. .
2. Create an API resource. .
3. Store data into a database. .
4. Transform the API data. .
5. Export the data to an application. .
6. Check and maintain the pipeline.

Plaid delivers a reliable and easy integration to Fidelity so that you can seamlessly power your Fintech innovation. Learn more about our API and data connectivity solutions.

1. In Sheets, open a spreadsheet.
2. In an empty cell, type =GOOGLEFINANCE.
3. In parenthesis, add any of the following, separated by a comma: A ticker symbol in quotation marks. (Optional) The attribute you want to show, such as price, in quotation marks. .
4. Press Enter.

The most common way to transfer stock between brokers is the direct transfer method. Most brokers use the Automated Customer Account Transfer Service (ACATS) to move investments this way. Here's how an ACATS transfer works: Start the process by filling out a transfer initiation form with your new broker.

You can rollover your current investments from either your Stash Invest account to another broker with what's known as an Automated Customer Account Transfer (ACAT). To perform the ACAT transfer, the receiving broker will need to make a request for an ACAT with our custodian, Apex Clearing.

1. Choose a New Broker. .
2. Submit a Transfer Initiation Form. .
3. Wait for the Receiving Firm to Contact Your Current Broker. .
4. Work With Your New Broker to Make Sure it Accepts All Your Assets. .
5. Wait for the Transfer To Be Completed.

The only option to transfer the mutual fund units to a person other than through inheritance is by way of the seller selling the units in the open market and the intended buyer purchasing the same at the relevant market price.

Fidelity doesn't charge a fee for sending or receiving EFTs, but the receiving bank may charge a fee. Fidelity also doesn't charge fees to process wire transfers to a bank or other recipient.

What is the best way to track a stock portfolio for an individual? ›

1. Use Online Tracking Services: Robo Advisors and Brokerages.
2. Track Your Investment with Personal Finance Apps.
3. DIY With Spreadsheets.
4. Use Desktop Apps for Investment Tracking.
5. Start Using a Trading Journal.

Having less than 20 stocks makes your portfolio concentrated and limits your chances of growth. It also increases risk because of under-diversification, as your portfolio only focuses on a particular sector, industry, or geography. Therefore, try to go over the limit of 20.

Fidelity emphasizes low fees with a great deal in return. Stash Investments offers even lower fees with much less in return. This article will try to determine which broker is the better deal.

Most portfolios can be transferred to a new provider as they are, however there are a few assets you may not be able to transfer directly. It can also take a little time for some assets to be released. This depends on the provider and is worth investigating before you make the move.

A “Personal Portfolio:” You can choose your own investments only in a “Personal Portfolio” which is a Non-Discretionary Managed account. A “Smart Portfolio” is a Discretionary Managed account whereby Stash has full authority to manage. A “Kids Portfolio” is a custodial UGMA / UTMA account.

Is it safe to keep more than $500,000 in a brokerage account? It is safe in the sense that there are measures in place to help investors recoup their investments before the SIPC steps in. And, indeed, the SIPC will not get involved until the liquidation process starts.

Generally there are no tax penalties or fees associated with moving investment funds from one brokerage firm to another. Some brokerage firms charge a fee to close an account or for some other service in connection with the transfer.

An in-kind or ACAT transfer allows you to transfer your investments between brokers as is, meaning you don't have to sell investments and transfer the cash proceeds — you can simply move your existing investments to the new broker.

1. Delivery Instruction Slip (DIS) which can be obtained from the other broker.
2. On the DIS, mention the number of units and the Zerodha demat account number. .
3. Submit the DIS to the other broker.

A Track your MF Investments using Fund Fact Sheet.. is a basic one-page document that gives an overview of a mutual fund scheme with special emphasis on disclosure of scheme performance and portfolio and is published every month by each mutual fund. It is like a report card that indicates the health of the scheme.

Do you pay taxes when you exchange mutual funds? ›

Yes, in order to make rebalancing easier you may exchange from one fund to one fund, one fund to many funds, or many funds to one fund. Is this exchange going to be reported to the IRS for tax purposes? An exchange between funds within a retirement account is not a taxable event and no tax form is generated.