Messages In This Digest (6 Messages)
- 1a.
- Too Many webpage retrievals From: Anant Upadhyayula
- 1b.
- Re: Too Many webpage retrievals From: Randy Harmelink
- 1c.
- Re: Too Many webpage retrievals From: Anant Upadhyayula
- 1d.
- Re: Too Many webpage retrievals From: Randy Harmelink
- 2a.
- How to find the exchange From: Anant Upadhyayula
- 2b.
- Re: How to find the exchange From: Randy Harmelink
Messages
- 1a.
-
Too Many webpage retrievals
Posted by: "Anant Upadhyayula" uanant@ymail.com uanant@ymail.com
Fri Jun 3, 2011 8:22 am (PDT)
Hello,
I am getting this error, "Too Many Webpage retrievals"
Is it common, i mean I have not used this much but just want to know how to overcome this issue.
thanks
AKu - 1b.
-
Re: Too Many webpage retrievals
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jun 3, 2011 8:59 am (PDT)
Because of the way the add-in extracts data from web pages, you get that
whenever you have tried to pull data from more than 1000 web pages in a
single session. The add-in is meant for ad hoc data retrieval, not for
wholesale exploitation of the free data sources.
For more info, read up on the smfForceRecalculation macro from the "Links"
area of the group. It can reset you back to zero web page retrievals.
However, it won't help if you have over 1000 web page retrievals in a single
workbook. I usually run the macro between closing one workbook and opening
another.
But I would not consider 1000 web pages to be "not used this much" -- that's
a LOT of data to be retrieved.
On Fri, Jun 3, 2011 at 8:22 AM, Anant Upadhyayula <uanant@ymail.com > wrote:
> I am getting this error, "Too Many Webpage retrievals"
>
> Is it common, i mean I have not used this much but just want to know how to
> overcome this issue.
>
>
- 1c.
-
Re: Too Many webpage retrievals
Posted by: "Anant Upadhyayula" uanant@ymail.com uanant@ymail.com
Fri Jun 3, 2011 12:08 pm (PDT)
I mean there are 2810 definitions in AdvFn.
This gives all financials data required for stock analysis, I am using RCHgetElementNumber() to retrieve the data from the webpage.
Is it possible that I am hitting 1000 mark everytime when I enter a ticker and try to update the data.
Am I doing something wrong?
thanks for your help
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, June 3, 2011 11:59 AM
Subject: Re: [smf_addin] Too Many webpage retrievals
Because of the way the add-in extracts data from web pages, you get that whenever you have tried to pull data from more than 1000 web pages in a single session. The add-in is meant for ad hoc data retrieval, not for wholesale exploitation of the free data sources.
For more info, read up on the smfForceRecalculation macro from the "Links" area of the group. It can reset you back to zero web page retrievals. However, it won't help if you have over 1000 web page retrievals in a single workbook. I usually run the macro between closing one workbook and opening another.
But I would not consider 1000 web pages to be "not used this much" -- that's a LOT of data to be retrieved.
On Fri, Jun 3, 2011 at 8:22 AM, Anant Upadhyayula <uanant@ymail.com > wrote:
I am getting this error, "Too Many Webpage retrievals"
>
>
>Is it common, i mean I have not used this much but just want to know how to overcome this issue.
>
- 1d.
-
Re: Too Many webpage retrievals
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jun 3, 2011 12:20 pm (PDT)
There are 2810 ANNUAL data elements for AdvFN. That's 2 web pages per ticker
symbol.
On Fri, Jun 3, 2011 at 12:08 PM, Anant Upadhyayula <uanant@ymail.com > wrote:
>
> I mean there are 2810 definitions in AdvFn.
> This gives all financials data required for stock analysis, I am using
> RCHgetElementNumber() to retrieve the data from the webpage.
> Is it possible that I am hitting 1000 mark everytime when I enter a ticker
> and try to update the data.
> Am I doing something wrong?
>
- 2a.
-
How to find the exchange
Posted by: "Anant Upadhyayula" uanant@ymail.com uanant@ymail.com
Fri Jun 3, 2011 3:09 pm (PDT)
Hi,
I can get the exchange information like this RCHGetElementNumber(Ticker,3) . This works great in excel and pulls the relevant exchange information.
What I would need help with is, if I can use this functionin VB to assign the value of exchange to a variable.
I am very new to VB, sorry if this is not the right place to ask this question
Aku - 2b.
-
Re: How to find the exchange
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jun 3, 2011 3:55 pm (PDT)
Check the "Links" area of the group....
On Fri, Jun 3, 2011 at 3:09 PM, Anant Upadhyayula <uanant@ymail.com > wrote:
> I can get the exchange information like this
> RCHGetElementNumber(Ticker,3) . This works great in excel and pulls the
> relevant exchange information.
>
> What I would need help with is, if I can use this function in VB to assign
> the value of exchange to a variable.
>
> I am very new to VB, sorry if this is not the right place to ask this
> question
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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