ETFsPortfolio analysis and optimizationPortfolio ManagementStock investments

Charles Schwab-Portfolio Management And Exporting To Excel

Written by Anangsha Saha (Individual Contributor)
Sun Mar 28 2021
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →

Charles Schwab is an investment firm that offers banking, brokerage and financial advisory services through its operating subsidiaries. In October 2020, Charles Schwab acquired TD Ameritrade, another brokerage firm, to scale up their operations and expand their consumer base. Since Charles Schwab is a full-service investment firm that relies on technology, it suits a large variety of investors, ranging from active traders with good market knowledge to clients who are simply looking for investment and portfolio-related advice.

Pros and cons of trading using Charles Schwab


  • It has a highly robust ETF screener on StreetSmart Edge. The ETF screener has over 150 screening criteria, including fund performance, asset classification, Morningstar categorisation, and so on.
  • The StreetSmart Edge is highly customisable, and the screener is available to both prospective and actual clients.
  • The web platform and the mobile apps have the same functionality. Schwab’s merger with OptionsXpress in 2010 helped in modernising the platforms to improve user experience.


  • Schwab does not offer automatic cash sweeps, meaning that uninvested cash is not automatically transferred to a money market fund. To earn interest on the money, one has to take action and move the funds themselves.
  • The ETF screener available on the website is fundamental and outdated compared to the ETF screener in SmartScreen Edge.
  • Most of the derivatives tools used by equities traders are only available on the SmartScreen Edge.

Let us now see how we can use Schwab’s trading platform to check our positions, assess the markets, find and analyse trade ideas and enter orders.

  1. We’ll start by taking a look at a customised account layout focused primarily on tracking your portfolio. You can review your current balances and buying power in Account Details. In the Positions tab, you can see position information down to individual lot details, as well as realised gain/loss for your closed positions.Charles Schwab
  2. To see market news, click on the Streaming News tab, which provides a continually updated news feed from, Reuters, and others. Here we add the company we’re interested in, to our watchlist.Charles SchwabCharles Schwab
  3. To further our research on our preferred company, we start with the fundamental analysis. The fundamentals of a security are easily viewed by right-clicking on the security’s name from the watchlist. This brings up the Research tool, populated with the information for that particular stock. The earnings tab is an intuitive snapshot of the security’s most recent earnings report.Charles SchwabCharles Schwab
  4. Now we can review the technical data for our company. To determine where it is trading relative to its support and resistance, choose from various technical studies built into StreetSmart Edge, such as Simple Moving Average and Bollinger Bands, which we see here.Charles Schwab
  5. After completing our analysis, we are ready to make the trade. Start by loading the symbol into the All-In-One Trade Tool. This powerful order entry window allows you to define the full trade parameters from entry to exit — for stocks, ETFs, and single- or multi-leg option orders. Once the parameters are set, review the order and confirm the trade.Charles Schwab

Exporting Transactions

You can export your transactions data to .xls (for Office XP and later versions), .csv, or .txt formats from the Actions menu or by right-clicking within the Transactions display. MarketXLS has a special offer for Schwab customers. Use code broker2021 for a 15% discount.

MarketXLS has a range of utility-based templates that take this downloaded input and turn your Charles Schwab’s portfolio into a portfolio analytics dashboard in Excel.

A portfolio is essentially a range of cells containing the stock symbols and weights of the stocks. All the stocks’ total weight should add up to 100% for a portfolio to be complete.

Here we are using the portfolio analysis template from MarketXLS, which has all the commands you need to analyse your portfolio with inbuilt into the template.


In this example, we have inserted our preferred stocks in cells B2 and B3 and their corresponding weights in C2 and C3. To calculate the portfolio’s monthly returns, we highlight the range of cells from B2 to C3 and use the function =MonthlyReturns(“Portfolio Range”). The default time period used is 12 months, but we can modify that by providing an optional integer value after the portfolio range.


The template contains functions to calculate the wealth index of the portfolio, which is also calculated for 12 months. It also calculates the Sortino and Sharpe Ratios, Mean Returns, Value at Risk, Portfolio Beta, Treynor Ratio, and so on.

MarketXLS also uses SQP optimisation techniques to calculate the Efficient Frontier, representing the set of efficient portfolios that will give the highest return at each level of risk or the lowest risk for each level of return. This frontier is formed by plotting the expected return on the y-axis and the standard deviation as a measure of risk on the x-axis.

efficient frontier

All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own or affiliation with the trademark owner.


None of the content published on constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein. The article is written to help users collect the required information from various sources deemed to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made.


Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Cowen Inc. logo

Cowen Inc.

Optionable: Yes
Market Cap: 859 M
Industry: Capital Markets
52 week range    
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

Optionable: Yes
Market Cap: 11,928 M
Industry: Business Services
52 week range    
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

Optionable: No
Market Cap: 2,846 M
Industry: Auto & Truck Dealerships
52 week range    
Amdocs Limited logo

Amdocs Limited

Optionable: Yes
Market Cap: 10,201 M
Industry: Software - Infrastructure
52 week range    
NBT Bancorp Inc. logo

NBT Bancorp Inc.

Optionable: Yes
Market Cap: 1,640 M
Industry: Banks - Regional - US
52 week range    
CRA InternationalInc. logo

CRA InternationalInc.

Optionable: Yes
Market Cap: 661 M
Industry: Business Services
52 week range    
CatchMark Timber Trust Inc. Class A logo

CatchMark Timber Trust Inc. Class A

Optionable: Yes
Market Cap: 504 M
Industry: REIT - Diversified
52 week range    
America's Car-Mart Inc. logo

America's Car-Mart Inc.

Optionable: Yes
Market Cap: 683 M
Industry: Auto & Truck Dealerships
52 week range    
ManTech International Corporation logo

ManTech International Corporation

Optionable: Yes
Market Cap: 3,917 M
Industry: Software - Application
52 week range    
CACI International Inc. Class A logo

CACI International Inc. Class A

Optionable: Yes
Market Cap: 6,536 M
Industry: Information Technology Services
52 week range    

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to to avail the extention

From all of us at MarketXLS, thank you!