How to analyze stock split information in Excel
What are stock splits, why are they important to investors and how can we easily analyze them in Excel?
Excel visualisation tips for stock portfolio and watchlist spreadsheets
We were recently involved in helping a customer build an stock watchlist Excel spreadsheet based around the Large Cap watchlist on the Yahoo Finance website. They wanted it to “look good” so here are some techniques we used to improve formatting and visualisations: Custom number format colours One useful Excel feature for financial spreadsheets is…
Excel Price Feed Add-in Release (v1.140)
Details on the latest release of the Excel Price Feed Add-in including a fix for pre and post market historical market data.
Chart Crime and Bubbles
There are lies, damned lies and statistics. There are also charts that are published to mislead or simply to reinforce a point of view that’s flimsy at best, or just plain wrong. We call these charts “chart crime”, let’s dig in…
How to use Excel to find the highest high and lowest low for a stock time series (including the date)
In this blog post we walk through how to use Excel to find the highest high and lowest low for a stock time series, including the date. We cover MATCH, ADDRESS and INDIRECT.
Excel Price Feed Add-in Release (v1.139)
Details on the latest release of the Excel Price Feed Add-in including a fix for pre and post market historical market data.
Excel Price Feed Add-in Release (v1.138)
Details on the latest release of the Excel Price Feed Add-in including a fix for pre and post market historical market data.
How to convert UTC to local time in Excel
How to convert UTC to local time in Excel using one simple formula
Understanding Company Retained Earnings
What are company retained earnings and how can we retrieve this data easily in Excel? In this article we compare retained earnings for Apple and Goldman Sachs, and explain how to easily retrieve this data in Excel.
Excel Price Feed Add-in Release (v1.128)
Details on the latest release of the Excel Price Feed Add-in including a fix for pre and post market historical market data.
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
The Excel Price Feed Blog 