Excel web querying stock and mutual fund info?

[rr76012]

Where can I go to download the excel template for web querying msn stock
quotes and information?

Thanks,
RR

 

[matt]

Where can I go to download the excel template for web querying msn stock
quotes and information?

Thanks,
RR

You can use the embedded smart tags in Excel. See Menu Bar: Tools/
AutoCorrect Options.../Smart Tags. Otherwise, search the Excel Help
for "Query for data from a Web page." You can then build your own
template because I'm sure you'll want to customize your output.

Matt

 

[rr76012]

Hello Matt,

Thanks, for your help. I am working on my mba in finance and want to start
investments in mutual funds and stocks. I am planning to build an excel web
query sheet. I want excel to act like a fund screener. For instance download
every short term bond fund. Then to download in separate columns, sharpe
ratio, beta, alpha, 1 year, 3 year and 5 year returns. I will then do some
analysis on the downloaded data.

I will start with your directions.

Matt, again thanks.

RR

 

[matt]

Hello Matt,

Thanks, for your help. I am working on my mba in finance and want to start
investments in mutual funds and stocks. I am planning to build an excel web
query sheet. I want excel to act like a fund screener. For instance download
every short term bond fund. Then to download in separate columns, sharpe
ratio, beta, alpha, 1 year, 3 year and 5 year returns. I will then do some
analysis on the downloaded data.

I will start with your directions.

Matt, again thanks.

RR







- Show quoted text -

One of the best ways to do record the syntax of a web query is to use
the macro recorder. When you do this, make sure that you use the VBE
Help to look up the query options, particularly .RefreshStyle
and .WebSelectionType. Personally, I typically use the xlOverWrite
for .RefreshStyle and xlEntriePage for .WebSelectionType.

Once you have the query figured out, you can then setup a variable or
an array for your tickers, encase the web query in a loop, copy your
output to the desired places, and then run your program on the
tickers.

Be sure to pick an appropriate benchmark for your alpha and make sure
that you know how the website is calculating beta. Also, make sure
that beta is really "telling" you the truth and decide whether or not
you like "volatility."

Matt

 

[Don Guillett]

Goto yahoo groups and join xltraders. You will like it. In the files
section, there are many files including my "YahooMultipleQuotes" that will
do what you like. Or, contact me OFF list and I will send. I will not
respond to a request made on the ng.

 

[rr76012]

Hello Don,

I will follow up and do both, I will join the xltraders and contact you
offline.
Thanks,
Rene

 

[rr76012]

One of the best ways to do record the syntax of a web query is to use
the macro recorder. When you do this, make sure that you use the VBE
Help to look up the query options, particularly .RefreshStyle
and .WebSelectionType. Personally, I typically use the xlOverWrite
for .RefreshStyle and xlEntriePage for .WebSelectionType.

Once you have the query figured out, you can then setup a variable or
an array for your tickers, encase the web query in a loop, copy your
output to the desired places, and then run your program on the
tickers.

Be sure to pick an appropriate benchmark for your alpha and make sure
that you know how the website is calculating beta. Also, make sure
that beta is really "telling" you the truth and decide whether or not
you like "volatility."

Matt