Messages In This Digest (6 Messages)
- 1a.
- NSE Quotes From: traderschat
- 1b.
- Re: NSE Quotes From: Randy Harmelink
- 1c.
- Re: NSE Quotes From: traderschat
- 1d.
- Re: NSE Quotes From: Randy Harmelink
- 2a.
- I am having trouble with RCHGetYahooQuotes() Excel function From: investor952
- 2b.
- Re: I am having trouble with RCHGetYahooQuotes() Excel function From: Randy Harmelink
Messages
- 1a.
-
NSE Quotes
Posted by: "traderschat" traderschat@yahoo.in traderschat
Thu Jan 5, 2012 2:35 am (PST)
Hi,
can anybody help me import data from nseindia.com.
historical LTP for last 10 days. and
High and Low for yesterday and OPEN , HIGH, & Low for todays
- 1b.
-
Re: NSE Quotes
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jan 5, 2012 2:38 am (PST)
Do a search on the message archives. It's been discussed before. If I
recall correctly, they generate the web pages dynamically, so it wasn't a
straight-forward extraction.
Ask again if something has changed. But please provide specific sample
URLs.
On Thu, Jan 5, 2012 at 3:04 AM, traderschat <traderschat@yahoo.in > wrote:
> can anybody help me import data from nseindia.com.
> historical LTP for last 10 days. and
> High and Low for yesterday and OPEN , HIGH, & Low for todays
>
- 1c.
-
Re: NSE Quotes
Posted by: "traderschat" traderschat@yahoo.in traderschat
Thu Jan 5, 2012 7:20 am (PST)
sir,
sorry to say that i haven't found a solution..i searched in the messages archives..but it dint help.
the link from which i need to extract the data is
http://www.nseindia.com/live_ market/dynaConte nt/live_watch/ get_quote/ GetQuoteFO. jsp?underlying= NIFTY&instrument =FUTIDX&expiry= 25JAN2012& type=-&strike= -
last 10 days LTP and HIGH LOW for yesterday
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Do a search on the message archives. It's been discussed before. If I
> recall correctly, they generate the web pages dynamically, so it wasn't a
> straight-forward extraction.
>
> Ask again if something has changed. But please provide specific sample
> URLs.
>
> On Thu, Jan 5, 2012 at 3:04 AM, traderschat <traderschat@...> wrote:
>
> > can anybody help me import data from nseindia.com.
> > historical LTP for last 10 days. and
> > High and Low for yesterday and OPEN , HIGH, & Low for todays
> >
>
- 1d.
-
Re: NSE Quotes
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jan 5, 2012 8:01 am (PST)
I don't see last 10 days of data on that URL. I do if I click the
"Historical Data" tab, but the add-in would need a bookmarkable URL that
gets directly to the data. The data is loaded via JavaScript, so the data
isn't within the source code of the web page, which is where it would need
to be for the add-in to extract it.
On Thu, Jan 5, 2012 at 8:20 AM, traderschat <traderschat@yahoo.in > wrote:
> sorry to say that i haven't found a solution..i searched in the messages
> archives..but it dint help.
>
> the link from which i need to extract the data is
>
> http://www.nseindia.com/live_ market/dynaConte nt/live_watch/ get_quote/ GetQuoteFO. jsp?underlying= NIFTY&instrument =FUTIDX&expiry= 25JAN2012& type=-&strike= -
>
> last 10 days LTP and HIGH LOW for yesterday
>
- 2a.
-
I am having trouble with RCHGetYahooQuotes() Excel function
Posted by: "investor952" investor952@yahoo.com investor952
Thu Jan 5, 2012 10:30 am (PST)
Last night and this morning, I am having trouble with this function in that there are several valid tickers that are returning an 'error' message for their price. I am using the formula
=RCHGetYahooQuotes(X,Y), where X is the ticker and Y is the smf code 'l1' . Note, some tickers are working, and others are returning this error. Below is a list of tickers that returned this error message the last time I tried it (about 20 minutes ago):
iqc
mua
evt
usb-pj
avv
mer-pp
jpm-pc
EEP
ohi
gsf
sxl
pmt
uan
ngg
pse
Prior to yesterday, I didn't have this problem.
I have not changed anything in my spreadsheet since it was working.
Thanks.
- 2b.
-
Re: I am having trouble with RCHGetYahooQuotes() Excel function
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jan 5, 2012 1:01 pm (PST)
I would suspect you're getting timeout errors from Yahoo. I had a few this
morning myself.
It should happen less often if you array-enter the formulas over a range --
then you can get all of the data in one Internet access instead of each
function going to the Internet on its own.
On Thu, Jan 5, 2012 at 11:30 AM, investor952 <investor952@yahoo.com > wrote:
> Last night and this morning, I am having trouble with this function in
> that there are several valid tickers that are returning an 'error' message
> for their price. I am using the formula
> =RCHGetYahooQuotes(X,Y), where X is the ticker and Y is the smf code 'l1'
> . Note, some tickers are working, and others are returning this error.
> Below is a list of tickers that returned this error message the last time I
> tried it (about 20 minutes ago):
>
> iqc
> mua
> evt
> usb-pj
> avv
> mer-pp
> jpm-pc
> EEP
> ohi
> gsf
> sxl
> pmt
> uan
> ngg
> pse
>
>
> Prior to yesterday, I didn't have this problem.
> I have not changed anything in my spreadsheet since it was working.
> Thanks.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar