How to Get the Last Trading Day of Each Month in Excel
How to get the last trading day of the month in your Excel spreadsheet using the Excel Price Feed Add-in. Useful for calculating monthly portfolio, stock or index returns.
New Date/Time Excel Formulas
New easy to use Excel formulas for current time in various time zone and for converting between time zones.
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
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 