Stock Quotes Wizard

This wizard helps you set the SQ( ), SQY( ), Indx( ), and Indx( ) functions, to make online queries from Yahoo! Finance and MSN Money.

You can use this wizard to enter these functions, or you can enter them manually, just like any other Excel function.

The above functions have the following arguments:

SQ("IBM", "Last")
As you can see, SQ( ) has two arguments, the company's ticker symbol and the type of data.
This function only retrieves current intraday data, as opposed to historical data.
The data is provided by MSN Money.

SQY("IBM","Last")
Here again you can see that SQY( ) has two arguments, the company's ticker symbol and the type of data.
This function only retrieves current intraday data, as opposed to historical data.
The data is provided by Yahoo! Finance.

Indx("$NL:AEX","Last" )
This function retrieves online stock market index data from MSN Money.
It does not get historical data.

Indxy("^DJA","Last" )

This function retrieves online stock market index data from Yahoo! Finance.
It does not get historical data.
The following example should clarify how this works:
Open the Stock Quotes Wizard dialog box.

You are shown the two possible data sources available to Stock Quotes. Choose Yahoo! Finance and click on Next.

This step is optional. If you do not want to query for stock market indices, just skip it by clicking Next.
This list includes all stock market indices available in Yahoo! Finance. Select the first four, click the Add -> button, and then Next.

In this step you can select the cells in your spreadsheet containing the ticker symbols to be queried.
You are provided with links to the websites to check for ticker symbols used by MSN Money and Yahoo! Finance if you want to.
Then click Next

In this step, select the data items to be queried.
For more information on data items, click here.
Choose the first four data items, click Add ->, and then Next.

Choose the cells in your spreadsheet where results will be pasted.
There is also an option checked by default that indicates if you want to get the data updated when you are finished.
If you do not uncheck it, all data will be updated as you finish.
Otherwise, you can always click on the "Refresh data" button to update the information.
Just click on Finish.

As you can see, this wizard entered the intended function for us, in this case, querying
for stock market indices from Yahoo! Finance.
Now you will have up-to-the-minute stock data directly on your spreadsheet!
You can also do this manually, or you can use the wizard.
Click here to see how to do it.