How to Load Stock Information in Excel? It’s Easier Than You Think

Stock Details in Excel

Stock Market Data in Excel

There are plenty of websites that display stock tickers, technical information, and other important stock Information.

Even though several websites do a fantastic job, sometimes you want to analyze them in your own little spreadsheet.

Getting Stock Market Data into Excel the Old fashioned way

Unless you are waiting for quotes in the next day’s paper, The slowest way to get stock information to Excel is to copy and paste from one website to another.

Hopefully, you’ve discovered the Stock function in Microsoft Excel. It’s an effective tool to upload current Stock Information into a spreadsheet.

Excel Stock Data

Here’s how many people use Excel’s stock functionality.
Type in the Ticker Symbol. Alt, A, D,1 if you need the shortcut!

Stock Tickers

Click the tiny grid symbol and choose the stock-related data that you want to add.

It will populate in the next open column.

Import Stock Data

This method can get a little wonky if you are trying to move columns around. There’s also a faster way.

The Faster Way to Load Stock data in Excel

Next time you want to agonize over how much money you lost in the Stock Market, try this.

First, set up your table with tickers, headers and add a calculation column. (Bought – Sold in Column H)

Populate data to Excel

Assuming we bought 100 shares at the 52 Week high and sold them at the 52 Week low, (the usual pattern(:), set up this calculation in column H. F-G * E.

Stock Update Template

Watch what happens if we reference the field with the stock ticker in it. Remember, we need the 52 weeks high and 52 week low.

In the formula, Cell enters the Cell name (the one with the ticker) followed by a period.


Stock Data Intellisense

As soon as you type D4 and the period, Excel immediately recognizes it is stock-related. IntelliSense kicks in displays our options. Referencing cells and using intelligence makes for quick Stock Market Data retrieval.

Try it out and have some fun importing Stock Data in Excel.

Latest Blog Posts

Learn about SQL joins using Excel

Learn about SQL joins using Excel

Why do we join tables in SQL? Tables that logically represent information are the foundation of relational databases. The ancient rules of database normalization remind us to arrange database tables to reduce redundancy and increase flexibility. An adequately...

Super Bowl Squares Template

Updated for Superbowl 57 This Version is unlocked, so be careful with the formulas. You have to press F9 to Regenerate the squares because calculations are set to manual. This spreadsheet is for educational purposes only. Please check your local gambling restrictions...

How to Return Multiple Matches in one Cell Using a lookup?

VLOOKUP is great for looking up a value and returning another corresponding value. But what happens when the first match just isn't enough. I've been tasked with finding a way to put return not just the first but the second, and third match. At first, I tried to...

How to Delete every other Row in Excel

How to Delete every other Row in Excel

Have you ever needed to delete every other row in Excel? You are not alone.   There are a few ways to accomplish it. It's a pretty good candidate for a VBA solution, but I'm going to show you how to quickly delete every other row without using VBA or a plugin. I...

Select the Email Service Provider that is right for you.

Select the Email Service Provider that is right for you. commits to continuous improvement. I've wondered if our Communication distribution process is lacking. Is there a more effective tool to help us share valuable content? Mailchimp has been's tool for email creation and...

Insert Multiple Rows into SQL table Using Excel as a Template

Insert Multiple Rows into SQL table Using Excel as a Template

I hope you followed the previous tutorial where we checked Created some brand new database tables using Excel as a template. Let's populate these tables with meaningful data. Okay, it might not be the most meaningful dataset since I just made this data up using...

Planning Software

Fiverr Freelancers

Share This