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

Excel 2013, Excel function 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:

http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=nsl1op&e=.csv

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:

https://code.google.com/p/yahoo-finance-managed/wiki/csvHistQuotesDownload

I can try using the following:

http://ichart.yahoo.com/table.csv?s=GOOG&a=0&b=1&c=2000&d=0&e=31&f=2010&g=w&ignore=.csv

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


***************************************************

8 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
site.



/blog/4577991494/Stock-Exchange-Tips-Everyone-Should-Know/6119528

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



fretfulidol2609.over-blog.com

Eոcore un article fοllement intéressant



http://direfulklutz2058.over-blog.com/2014/05/le-site-personnel-d-un-pervers.Html

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.



Lyndon

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



Comments

Please Leave a Comment!





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