Building A Stock Spreadsheet In Excel 2013 Using The Webservice Function (Part 1)

Excel 2013, Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to for professional help and Excel Tutorials

After introducing the new webservice function that was added to Excel 2013, I’m looking to build my first spreadsheet today and I thought it’d be interesting to build a spreadsheet that can access the Yahoo finance API. Let’s start off by building a sheet that will display information about a specific stock which I can change. I will start off by adding a place where I’d have that stock’s ticker:

Then, when I go to the Yahoo API explanation page, I see that I can get access to the stock’s price with this URL:

I will simply change that “GOOG” reference to the cell C2 and look at the result:

Then, I could simply access the price from that cell using the “mid” function. Let’s try something else though. I would like to pull the close of every day since January 2012, to build myself a nice chart. Using the function found in:

I can try using the following:

Again, I will replace “GOOG” with a reference to cell C2:

Again, some formatting would be required but I think this gives you an idea of how poerful these webservices are as you can easily get in a ton of data about any stock. As a last addition for today, I will add news about Apple using the Yahoo news RSS for Apple. First, I went to Yahoo’s Apple page and got the URL of its RSS news here:

Then, I went into Excel, in the developer tab and clicked on source where I added that and dragged it into my spreadsheet as you can see here:

There are many other ways all of this can be done but it does give you an idea of the possibilites offered thanks to XML and webservices functions in Excel 2013… More on this very soon!


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


9 Feedbacks on "Building A Stock Spreadsheet In Excel 2013 Using The Webservice Function (Part 1)"

Immigration Advisers folkstone

Greate pieces. Keep writing such kind of info on your blog.
Im really impressed by your site.
Hello there, You have performed a fantastic job. I will certainly
digg it and personally suggest to my friends. I’m sure they’ll be benefited from this web


an encouraging medication advertising and dispersing organization with growing money flows,
liaisons with big international vendors, strong historical relationships, a small Paladin-like organization and dealt with
by just one expert thus far.

oil jobs

Oh my goodness! Awesome article dude! Thanks, However I am having issues
with your RSS. I don’t understand why I cannot join it. Is there anybody getting the same RSS issues? Anybody who knows the solution can you kindly respond? Thanx!!

scène splendidement gonzo de plaisir solitaire captivant

Uո imposant merci à l’admin de ce sitе web

Eոcore un article fοllement intéressant

Je poste un petit commentaire uniquement pour complimenter l’administrateur

fotos de naruto y sakura

An impressive share! I’ve just forwarded this onto a coworker who had been doing a little
homework on this. And he in fact bought me breakfast simply because
I found it for him… lol. So let me reword this…. Thank YOU for the meal!!

But yeah, thanx for spending time to talk about this subject here on your website.


Hey! This is kind of off topic but I need some guidance from an established blog.
Is it very hard to set up your own blog? I’m not
very techincal butt I can figure things out pretty fast. I’m thinking about making my
ownn but I’m not sure where to begin. Do you have any tips or suggestions?
Many thanks

hardwood floor iphone water damage repairs

Spot on with this write-up, I actually feel this amazing site needs far more attention. I’ll probably be back
again to read more, thanks for the advice!


Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.