How to get mutual fund symbol price in excel

RahulNa

Board Regular
Joined
Jul 12, 2012
Messages
124
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have a column of 10 to 15 share symbol in which I need to get price updated on daily basis from NASDAQ.

Is there anyway that the same can be automated?
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Here is a link to an add in I employ

www.parago.de


Hi,

I tried the same but it's giving an error (ERROR: Couldn't retrieve and/or process financial data from internet service. Internal message: The remote server returned an error: (999) Request denied.)

Is there any other method.
 
Upvote 0
This is a long thread, but there are several options listed (interspersed) in the thread. https://www.mrexcel.com/forum/excel...k-quotes-changed.html?highlight=Yahoo+Finance

Regarding the post above, I suspect you have a installation issue as this one works with out issue for me. I am running Win10 Excel 2016 if that makes a difference.

Additionally, this also works for me.

=NUMBERVALUE(WEBSERVICE("http://download.finance.yahoo.com/d/quotes.csv?s="&E1&"&f=l1"))

Where the stock symbol is in Cell E1
 
Last edited:
Upvote 0
This is a long thread, but there are several options listed (interspersed) in the thread. https://www.mrexcel.com/forum/excel...k-quotes-changed.html?highlight=Yahoo+Finance

Regarding the post above, I suspect you have a installation issue as this one works with out issue for me. I am running Win10 Excel 2016 if that makes a difference.

Additionally, this also works for me.

=NUMBERVALUE(WEBSERVICE("http://download.finance.yahoo.com/d/quotes.csv?s="&E1&"&f=l1"))

Where the stock symbol is in Cell E1


Hi Sir,

Thanks for the reply.

The link shared is not working. As yahoo has shutdown that link.

Please let me know if there is any other way.
 
Upvote 0
The Wall Street Journal has a mutual fund closing price listing. Because of the quantity of funds the pages are broken out by the first letter of the fund symbol. This link has funds beginning with "B".
http://www.wsj.com/mdc/public/page/2_3048-usmfunds_B-usmfunds.html

I would suggest using PowerQuery to pull the desired symbols from the relevant pages and merge them. Depending on how many different first letters you have you might just want to pull all 26 pages in case you need to pull new funds at some point. I use the similar WSJ currency page for daily currency conversion values.
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,560
Latest member
Torchwood72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top