Can you Modify the preset stock query

A

AlekM

The Excel 2003 query for stock quotes is convinient to use, but I woul
like to add some additional columns after the last column "share
outstanding". For example I would like to attach the financial ratios
which can be downloaded as a web query, but they do not fit in th
layout of the stock quotes query. That brings me to another question.

I use a web query to download the financial ratios they are returned i
the format

Debt/Equity Ratio 2.2
Current Ratio 1.4
Quick Ratio 1.1

Where if I would attach them in the stock quotes query, then I nee
them to be

Debt/Equity Ratio Current Ratio Quick Ratio
2.2 1.4 1.1

Any help is much appreciated Thank
 
Top