Requesting “urgent” usually turns me OFF and results in me DELETING the
message, but.
You can use that url and get the prices but only like this so you would need to
parse out the info.Instead try Yahoo.
http://finance.yahoo.com/q?s=JUBLFOOD.NS&ql=1 I can send a file.
{"futLink":"\/live_market\/dynaContent\/live_watch\/get_quote\/GetQuoteFO.jsp?underlying=JUBLFOOD&instrument=FUTSTK&expiry=23FEB2012&type=-&strike=-","otherSeries":["EQ"],"lastUpdateTime":"13-FEB-2012
16:00:13","tradedDate":"13FEB2012","data":[{"extremeLossMargin":"5.36","bcStartDate":"13-AUG-11","change":"-0.70","buyQuantity3":"-","sellPrice1":"999.75","buyQuantity4":"-","sellPrice2":"-","priceBand":"No
Band","buyQuantity1":"-","deliveryQuantity":"2,11,877","buyQuantity2":"-","cm_adj_low":"467.10","sellPrice5":"-","quantityTraded":"10,95,536","buyQuantity5":"-","sellPrice3":"-","sellPrice4":"-","open":"1,005.30","cm_adj_high":"1,049.70","low52":"484.50","securityVar":"13.65","marketType":"N","pricebandupper":"No
Price
Band","totalTradedValue":"11,010.58","faceValue":"10.00","ndStartDate":"-","previousClose":"1,000.40","symbol":"JUBLFOOD","varMargin":"13.65","lastPrice":"999.70","pChange":"-0.07","adhocMargin":"-","companyName":"Jubilant
Foodworks
Limited","averagePrice":"1,005.04","secDate":"13FEB2012","series":"EQ","isinCode":"INE797F01012","indexVar":"-","pricebandlower":"No
Price Band","totalBuyQuantity":"-","high52":"1,049.70","purpose":"ANNUAL
GENERAL
MEETING","cm_adj_low_dt":"10-FEB-11","closePrice":"999.75","recordDate":"-","cm_adj_high_dt":"10-FEB-12","totalSellQuantity":"379","dayHigh":"1,021.15","exDate":"11-AUG-11","sellQuantity5":"-","bcEndDate":"20-AUG-11","ndEndDate":"-","sellQuantity2":"-","sellQuantity1":"379","buyPrice1":"-","sellQuantity4":"-","buyPrice2":"-","sellQuantity3":"-","applicableMargin":"19.01","buyPrice4":"-","buyPrice3":"-","buyPrice5":"-","dayLow":"984.25","deliveryToTradedQuantity":"19.34","totalTradedVolume":"10,95,536"}],"optLink":"\/marketinfo\/sym_map\/symbolMapping.jsp?symbol=JUBLFOOD&instrument=-&date=-&segmentLink=17&symbolCount=2"}
Yahoo
999.75 Down0.65(0.06%) 5:28AM EST
Add to Portfolio
Prev Close: 1,000.40
Open: 1,005.30
Bid: 999.10
Ask: 999.75
1y Target Est: N/A
Beta: N/A
Next Earnings Date: N/A
Day's Range: 984.25 - 1,021.15
52wk Range: 484.50 - 1,049.70
Volume: 1,095,536
Avg Vol (3m): 1,059,540
Market Cap: N/A
P/E (ttm): N/A
EPS (ttm): N/A
Div & Yield: N/A (N/A)
================
Don Guillett
SalesAid Software
dguille...@gmail.com
From: sharad jain
Sent: Sunday, February 12, 2012 10:37 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Price Download from NSE - Urgent
Hi Experts,
Can anyone suggest a way to directly download the prices from NSE website? I
can provide ticker in a cell.
I am talking about downloading the latest price following url:
http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD
Please treat this as an urgency.
Thanks,
Sharad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
