Yahoo Finance ‘Market Pricer’ Custom Function

I’ve created a Yahoo Finance ‘Market Pricer’ Custom Function for Excel  that you can use to  import current Yahoo finance prices for your Stocks, Mutual Funds and ETFs.  The video below In this video I demonstrate my Yahoo Finance ‘Market Pricer’ Custom function.  It has two arguments the Stock, Mutual Fund or ETF ticker (symbol) and the Market data you are seeking.
1) Market Price
2) Exchange
3) Instrument Type
4) Previous Close
5) Post close Pricing
It uses an VBA httpRequest and Yahoo finance API to Yahoo Finance Pricing.
Yahoo Finance 'Market Pricer' Custom Function
In order to use the Yahoo Finance API you’ll need to include the Microsoft WinHTTP Services version 5.1 as a reference.
The interesting thing, In my opinion, is that only 5 lines of code are used to return the Data from Yahoo.  the remaining code is used to parse out the market price, instrument type, exchange etc,. from all the data sent my yahoo including interday pricing.
Image

Excel Stock Prices from Yahoo Finance Custom Function

Use this download t0 get a copy my excel yahoo finance stock pricer custom function. Please check that my tool is working correctly for you.  Always check and double check all your spreadsheets to ensure accurate results.

If you were able to utilize what you learned here or improved the code,
please leave a comment Here

If you enjoyed this post or found it helpful andl would like to say hello and
buy me a cup of coffee Click here

Raymond Mills MBA, MS
Raymond Mills, M.B.A., M.S.  has spent over 20 years of his career as Accountant, Investment Bank and Credit Card Technical Auditor/ Data Analyst.  His specialty was using Excel to get Big Databases including Teradata, Oracle,  Squel Server and Sybase to give up their secrets. Ray has said “I love nothing better than using VBA to unleash the power of Microsoft Office.” You can contact Ray @ 484 574-3190 or by emailing him Here

If you have a challenge with Excel, Access or Word and would like to speak with Ray,   You can get his contact details by clicking here: Contact Me

Comments are closed.