In a Google Docs spreadsheet, I can use this cell formula:

1. Download Stock Prices In Excel

to download the latest price of a stock. Is there an equivalent function in Excel 2013?

Earlier versions of Excel had a smart tag feature that downloaded a ton of data for each ticker (too much, in fact, if you just need the price), and I've seen sources that suggest the Bing Finance app for Excel 2013. Unfortunately this has been discontinued.

Microsoft has a new feature that returns free, real-time stock prices for about 7500 ticker symbols from exchanges around the world. You may access it if you have Excel 2016 on an Office 365 subscription.

Is there a simple way to do this? I literally just need the most recent price, and I don't care if it's delayed, comes from Yahoo Finance, etc. Presumably I could write VBA code to download a CSV file from YF, parse it and so on, but I'm hoping to avoid creating a macro-enabled workbook.

RaystafarianMichael AMichael A

3 Answers

You can use a UDF like this -

Now you can use GetTickerPrice('GOOG') and get the current price.

I did take this over to Codereview.SE for some input.

RaystafarianRaystafarian

There are four Stock apps in the Office Store at the moment.Two of them are free :

harrymcharrymc

There is an Add-In called Stock Quote Add-In For Excel 2013 which does this, and has a version for 2013. Personally I could not get it to work, but it has been around for a few years so it was probably just me.

Raystafarian

protected by Community♦Jan 11 '15 at 9:11

Download Stock Prices In Excel

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged microsoft-excelworksheet-functionvbamicrosoft-excel-2013 or ask your own question.