| User | Post |
|
5:18 pm
January 5, 2012
|
jalleninvest
| | Coronado, CA | |
| Member | posts 22 |
|
|
rharmelink said:
When most of the add-in functions are invoked, they actually extract data from a copy of the web page that was saved by the add-in. This is done to make the functions run more quickly, because the actual retrieval of a web page from the Internet is the part of the process that takes the most time. For example, if you were to get 20 or 30 data items from the same web page, this process allows the web page to be retrieved once and then all extractions are done from that single retrieval of the web page from the Internet. Otherwise, each invocation of those functions would need to grab a new web page.
In general, the process operates as follows:
- The "saved array" is first checked, to see if the web page the data is being extracted from has already been retrieved from the Internet.
- If an entry in the "saved array" is found, the data is extracted from the saved copy of the web page.
- If an entry is not found in the "saved array", the source code of the web page is retrieved from the Internet and then put into the "saved array", which is indexed by URL. Then, the data is extracted from that saved copy of the web page.
However, that "saved array" is sized at 1000 web pages.
I'm glad I'm an investment guy and not a computer genius, or maybe if I was, reading your post wouldn't make my head hurt!
I have no idea how this works, and it appears I am destined to have it remain that way.
Thanks, though.
|
|
|
7:47 pm
January 4, 2012
|
rharmelink
| | |
| Member | posts 8 |
|
|
Post edited 11:48 am – January 4, 2012 by rharmelink
When most of the add-in functions are invoked, they actually extract data from a copy of the web page that was saved by the add-in. This is done to make the functions run more quickly, because the actual retrieval of a web page from the Internet is the part of the process that takes the most time. For example, if you were to get 20 or 30 data items from the same web page, this process allows the web page to be retrieved once and then all extractions are done from that single retrieval of the web page from the Internet. Otherwise, each invocation of those functions would need to grab a new web page.
In general, the process operates as follows:
- The "saved array" is first checked, to see if the web page the data is being extracted from has already been retrieved from the Internet.
- If an entry in the "saved array" is found, the data is extracted from the saved copy of the web page.
- If an entry is not found in the "saved array", the source code of the web page is retrieved from the Internet and then put into the "saved array", which is indexed by URL. Then, the data is extracted from that saved copy of the web page.
However, that "saved array" is sized at 1000 web pages.
|
|
|
4:11 pm
January 4, 2012
|
Jae Jun
| | |
| Admin
| posts 1453 |
|
|
yes excel sets it. Save the file you're working on. Close excel completely and reopen.
|
|
|
4:01 pm
January 4, 2012
|
jalleninvest
| | Coronado, CA | |
| Member | posts 22 |
|
|
Post edited 8:01 am – January 4, 2012 by jalleninvest
I was sitting here running analysis on the stocks that show up on one of my screens. At no. 48, I start getting "Error – too many webpage retrievals."
What is this? Is there a limit? Who sets it? Where does the data come from?
|
|
Home
