Import from Y A H O O into Excel using Web-query!

chachi

Active Member
#11
Hi Chachi,
By using "GetQuoteNew" requested data is coming but not in formated form in DATA sheet.

Regard,
MK Singh
Dear Singh

DATA sheet is a raw sheet used to gather data from yhoo site. You should use only the first sheet by name "SYMBOL". Here you can add/delete/modify the scrips. Also you can format this page according to your needs.

Regards
Chachi
 
#12
In Vista After clicking REFRESH botton, it is giving " Compile error in hidden module:Macros" and no data is coming in SYMBOL sheet. Data only comes in Data sheet in unformated form.

^BSESN,14543.73,"8/19/2008",0.00,14517.76,14604.11,14368.72,14543.73,0
PTC.NS,83.80,"8/19/2008",+0.15,83.00,84.45,82.00,83.65,489061
HARRMALAY.NS,100.80,"8/19/2008",+0.55,98.40,103.00,98.00,100.25,86559
CMC.NS,541.20,"8/19/2008",+6.20,535.00,545.00,532.30,535.00,2696
TIMKEN.NS,104.70,"8/19/2008",-0.65,102.20,106.80,102.20,105.35,1826
POCHIRAJU.NS,21.20,"8/19/2008",+0.25,20.45,21.65,20.30,20.95,47040
RNRL.NS,95.35,"8/19/2008",+0.55,94.05,97.30,92.30,94.80,26957320
RELCAPITA.NS,1273.25,"8/19/2008",-13.35,1277.70,1288.00,1245.00,1286.60,2856270
UNITY.NS,443.85,"8/19/2008",-5.95,442.00,451.00,437.30,449.80,12718
NOCIL.NS,26.05,"8/19/2008",-0.50,26.30,26.60,25.75,26.55,431637
LITL.NS,304.10,"8/19/2008",+7.10,297.50,308.00,290.30,297.00,1397123
NIRMA.NS,132.95,"8/19/2008",+0.55,134.00,134.35,132.00,132.40,4529
MARUTI.NS,616.50,"8/19/2008",-23.60,639.85,639.85,601.95,640.10,1380725
VLSFINANC.NS,15.70,"8/19/2008",-0.35,16.25,16.25,15.50,16.05,11204
KEI.NS,38.55,"8/19/2008",-0.80,39.10,39.60,38.30,39.35,91246
DISHTV.NS,38.10,"8/19/2008",+0.95,37.00,38.70,36.35,37.15,5162438

I am using Excel 2007.
I will check it in XP.
Regard,
MK Singh
 
Last edited:
#13
Hi Kcubes,

Just to solve your first query try this.

While creating the web query OR after creating the web query, go to data range properties and select "Overwrite existing cells with new data, clear unused cells". Create this for every stock you list.

if the above do not work, the following is a fool proof method....

copy http://download.finance.*****.com/d/quotes.csv?s=RNRL.NS+RPL.NS+NTPC.NS+ACC.NS&f=l1 into your web query and change/add the stock names as required. There seems to be a limitation for adding no. of stocks (may be around 10). This will list the prices one below the other.

@ chachi

The first trick is not working, but the second trick is working just fine and is giving desired results.

Now the only problem lies is that I want to modify the web query automatically based on the changes that I make in the column where I'm writing the script names. Without keeping gaps/blanks in between, I might want to modify, add or delete the script in the column. And so the web query should also change without me having to do it manually.

Thanks and regards,

kcubes.
 
#14
In Vista After clicking REFRESH botton, it is giving " Compile error in hidden module:Macros" and no data is coming in SYMBOL sheet. Data only comes in Data sheet in unformated form.

^BSESN,14543.73,"8/19/2008",0.00,14517.76,14604.11,14368.72,14543.73,0
PTC.NS,83.80,"8/19/2008",+0.15,83.00,84.45,82.00,83.65,489061
HARRMALAY.NS,100.80,"8/19/2008",+0.55,98.40,103.00,98.00,100.25,86559
CMC.NS,541.20,"8/19/2008",+6.20,535.00,545.00,532.30,535.00,2696
TIMKEN.NS,104.70,"8/19/2008",-0.65,102.20,106.80,102.20,105.35,1826
POCHIRAJU.NS,21.20,"8/19/2008",+0.25,20.45,21.65,20.30,20.95,47040
RNRL.NS,95.35,"8/19/2008",+0.55,94.05,97.30,92.30,94.80,26957320
RELCAPITA.NS,1273.25,"8/19/2008",-13.35,1277.70,1288.00,1245.00,1286.60,2856270
UNITY.NS,443.85,"8/19/2008",-5.95,442.00,451.00,437.30,449.80,12718
NOCIL.NS,26.05,"8/19/2008",-0.50,26.30,26.60,25.75,26.55,431637
LITL.NS,304.10,"8/19/2008",+7.10,297.50,308.00,290.30,297.00,1397123
NIRMA.NS,132.95,"8/19/2008",+0.55,134.00,134.35,132.00,132.40,4529
MARUTI.NS,616.50,"8/19/2008",-23.60,639.85,639.85,601.95,640.10,1380725
VLSFINANC.NS,15.70,"8/19/2008",-0.35,16.25,16.25,15.50,16.05,11204
KEI.NS,38.55,"8/19/2008",-0.80,39.10,39.60,38.30,39.35,91246
DISHTV.NS,38.10,"8/19/2008",+0.95,37.00,38.70,36.35,37.15,5162438

I am using Excel 2007.
I will check it in XP.
Regard,
MK Singh
@ chachi,

Mr MK Singh is right, even I'm getting exactly the same error.

I'm using Excel 2007 and Windows XP SP3.

Regards,

kcubes.
 

Similar threads