12 New Messages
Digest #2737
Messages
Sat Aug 17, 2013 12:04 pm (PDT) . Posted by:
"Regie" gawaine43
The problem with Zacks, MSN, etc is a function of them limiting the number of queries (stocks) per session. The most concrete and consistent example I have are Zacks and Reuters; you can download info on 500 or 1000 stocks, respectively, then you have to reboot your computer. Zacks appears very restrictive; if you happen to go over 500 queries, then they ban your home IP from even visiting their site. This ban may last for months and could be inconvenient if you have fixed broadband (DSL/cable). With MSN, Morningstar or others, sometimes I get 200 up to 500 before needing to reboot.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> Others have mentioned troubles with Zacks, but they cannot even visit the
> website with their browser.
>
> I've not had issues with MSN, other than people having old element
> definitions (they updated their website structure early last year).
>
> On Sun, Jun 9, 2013 at 8:18 AM, handc.jones@... <
> handc.jones@...> wrote:
>
> >
> > I would love to use your add in more effectively to extract data from the
> > various sites. I have no problem extracting data from Yahoo Finance but
> > for some reason cannot extract data from MSN, Zachs, Morningstar. For
> > example, I opened the file from your site
> > http://finance.groups.yahoo.com/group/smf_addin/?prop=eupdate "Consistency Investment Spreadsheet" and had errors on the 3 sites
> > mentioned. Data from Yahoo was ok.
> >
> > I am using a PC with Windows Office 2010.
> >
>
--- In smf_addin@yahoogrou
> Others have mentioned troubles with Zacks, but they cannot even visit the
> website with their browser.
>
> I've not had issues with MSN, other than people having old element
> definitions (they updated their website structure early last year).
>
> On Sun, Jun 9, 2013 at 8:18 AM, handc.jones@
> handc.jones@
>
> >
> > I would love to use your add in more effectively to extract data from the
> > various sites. I have no problem extracting data from Yahoo Finance but
> > for some reason cannot extract data from MSN, Zachs, Morningstar. For
> > example, I opened the file from your site
> > http://finance.
> > mentioned. Data from Yahoo was ok.
> >
> > I am using a PC with Windows Office 2010.
> >
>
Sat Aug 17, 2013 12:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you sure you're not just hitting the add-in's built in limitation of
1000 web pages per "session"? For example, if you get data from 5 web pages
for each stock, you'll hit that limitation at 200 stocks. It should return
an error message that says too many web page retrievals.
In most situations, I would consider that many stocks to be an outrageous
amount, so I wouldn't consider such limits restrictive. The add-in is
designed for ad hoc data retrieval, not for population of databases and/or
screening tools. Screening should be done BEFORE using the add-in to get
more detailed data.
And, in some cases, it's just doing things smarter. For example, if you're
getting the same fields on a number of stocks from Zacks, it would be a lot
easier to use their screener to create a view with those fields, use a
selection criteria that would include your stocks, and then export the CSV
file that is a result of the screen.
I just used a criteria of last price > $5, then included fields like Zacks
Ranks and Zacks Recommendation. My export file had 6232 stocks on it, and
downloaded in a matter of seconds. Now I can do VLOOKUP() functions on that
data, which would be a heck of a lot more efficient that grabbing data one
web page at a time.
On Sat, Aug 17, 2013 at 10:49 AM, Regie <gawaine43@yahoo.com > wrote:
> The problem with Zacks, MSN, etc is a function of them limiting the number
> of queries (stocks) per session. The most concrete and consistent example I
> have are Zacks and Reuters; you can download info on 500 or 1000 stocks,
> respectively, then you have to reboot your computer. Zacks appears very
> restrictive; if you happen to go over 500 queries, then they ban your home
> IP from even visiting their site. This ban may last for months and could be
> inconvenient if you have fixed broadband (DSL/cable). With MSN, Morningstar
> or others, sometimes I get 200 up to 500 before needing to reboot.
>
1000 web pages per "session"
for each stock, you'll hit that limitation at 200 stocks. It should return
an error message that says too many web page retrievals.
In most situations, I would consider that many stocks to be an outrageous
amount, so I wouldn't consider such limits restrictive. The add-in is
designed for ad hoc data retrieval, not for population of databases and/or
screening tools. Screening should be done BEFORE using the add-in to get
more detailed data.
And, in some cases, it's just doing things smarter. For example, if you're
getting the same fields on a number of stocks from Zacks, it would be a lot
easier to use their screener to create a view with those fields, use a
selection criteria that would include your stocks, and then export the CSV
file that is a result of the screen.
I just used a criteria of last price > $5, then included fields like Zacks
Ranks and Zacks Recommendation. My export file had 6232 stocks on it, and
downloaded in a matter of seconds. Now I can do VLOOKUP() functions on that
data, which would be a heck of a lot more efficient that grabbing data one
web page at a time.
On Sat, Aug 17, 2013 at 10:49 AM, Regie <gawaine43@yahoo.
> The problem with Zacks, MSN, etc is a function of them limiting the number
> of queries (stocks) per session. The most concrete and consistent example I
> have are Zacks and Reuters; you can download info on 500 or 1000 stocks,
> respectively, then you have to reboot your computer. Zacks appears very
> restrictive; if you happen to go over 500 queries, then they ban your home
> IP from even visiting their site. This ban may last for months and could be
> inconvenient if you have fixed broadband (DSL/cable). With MSN, Morningstar
> or others, sometimes I get 200 up to 500 before needing to reboot.
>
Sat Aug 17, 2013 2:58 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Does it count as multiple web pages (toward the limitation) when you have multiple cells pull different data from the same web page?
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Saturday, August 17, 2013 3:17 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Extracting Data from Some sites are a Problem
Are you sure you're not just hitting the add-in's built in limitation of 1000 web pages per "session"? For example, if you get data from 5 web pages for each stock, you'll hit that limitation at 200 stocks. It should return an error message that says too many web page retrievals.
In most situations, I would consider that many stocks to be an outrageous amount, so I wouldn't consider such limits restrictive. The add-in is designed for ad hoc data retrieval, not for population of databases and/or screening tools. Screening should be done BEFORE using the add-in to get more detailed data.
And, in some cases, it's just doing things smarter. For example, if you're getting the same fields on a number of stocks from Zacks, it would be a lot easier to use their screener to create a view with those fields, use a selection criteria that would include your stocks, and then export the CSV file that is a result of the screen.
I just used a criteria of last price > $5, then included fields like Zacks Ranks and Zacks Recommendation. My export file had 6232 stocks on it, and downloaded in a matter of seconds. Now I can do VLOOKUP() functions on that data, which would be a heck of a lot more efficient that grabbing data one web page at a time.
On Sat, Aug 17, 2013 at 10:49 AM, Regie <gawaine43@yahoo.com > wrote:
The problem with Zacks, MSN, etc is a function of them limiting the number of queries (stocks) per session. The most concrete and consistent example I have are Zacks and Reuters; you can download info on 500 or 1000 stocks, respectively, then you have to reboot your computer. Zacks appears very restrictive; if you happen to go over 500 queries, then they ban your home IP from even visiting their site. This ban may last for months and could be inconvenient if you have fixed broadband (DSL/cable). With MSN, Morningstar or others, sometimes I get 200 up to 500 before needing to reboot.
Thanks,
Jim
From: smf_addin@yahoogrou
Sent: Saturday, August 17, 2013 3:17 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: Extracting Data from Some sites are a Problem
Are you sure you're not just hitting the add-in's built in limitation of 1000 web pages per "session"
In most situations, I would consider that many stocks to be an outrageous amount, so I wouldn't consider such limits restrictive. The add-in is designed for ad hoc data retrieval, not for population of databases and/or screening tools. Screening should be done BEFORE using the add-in to get more detailed data.
And, in some cases, it's just doing things smarter. For example, if you're getting the same fields on a number of stocks from Zacks, it would be a lot easier to use their screener to create a view with those fields, use a selection criteria that would include your stocks, and then export the CSV file that is a result of the screen.
I just used a criteria of last price > $5, then included fields like Zacks Ranks and Zacks Recommendation. My export file had 6232 stocks on it, and downloaded in a matter of seconds. Now I can do VLOOKUP() functions on that data, which would be a heck of a lot more efficient that grabbing data one web page at a time.
On Sat, Aug 17, 2013 at 10:49 AM, Regie <gawaine43@yahoo.
The problem with Zacks, MSN, etc is a function of them limiting the number of queries (stocks) per session. The most concrete and consistent example I have are Zacks and Reuters; you can download info on 500 or 1000 stocks, respectively, then you have to reboot your computer. Zacks appears very restrictive; if you happen to go over 500 queries, then they ban your home IP from even visiting their site. This ban may last for months and could be inconvenient if you have fixed broadband (DSL/cable). With MSN, Morningstar or others, sometimes I get 200 up to 500 before needing to reboot.
Sat Aug 17, 2013 4:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
No. The add-in saves a copy of the web page, then extracts data from that
saved copy. So if you have 10 data items from that web page, they all come
from the same saved copy of the web page. But the add-in only has room to
save 1000 web pages, which is what causes the limitation.
On Sat, Aug 17, 2013 at 2:58 PM, Jim Ranum <amt2100@gmail.com > wrote:
>
> Does it count as multiple web pages (toward the limitation) when you have
> multiple cells pull different data from the same web page?
>
saved copy. So if you have 10 data items from that web page, they all come
from the same saved copy of the web page. But the add-in only has room to
save 1000 web pages, which is what causes the limitation.
On Sat, Aug 17, 2013 at 2:58 PM, Jim Ranum <amt2100@gmail.
>
> Does it count as multiple web pages (toward the limitation) when you have
> multiple cells pull different data from the same web page?
>
Sat Aug 17, 2013 12:36 pm (PDT) . Posted by:
"kkkutty" kkkutty
Hi Randy,
I apologize about the spam issue. If it happens again I can login with a new email account.
Quick question...I'm still unable to extract the last 20 quarters of financial data from AdvFN even with the "ih" fix. For example when I enter RCHGetElementNumber("GOOG";, 8006), I get "2013/03". And when I enter RCHGetElementNumber("GOOG";, 8010), I also get "2013/03". My SMF Add-in folder is located in the C:\program files\ folder (I'm not sure why that is)instead of C:\, but that should not make a difference, right? Any idea of how I can resolve this issue? Thanks in advance for your input.
I apologize about the spam issue. If it happens again I can login with a new email account.
Quick question...I&#
Sat Aug 17, 2013 1:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Where the add-in is located makes no difference. But the prefix file needs
to be in that same folder.
OK, try this:
1. Close down all open workbooks
2. Open a new workbook
3. Run the smfForceRecalculation macro
Now, what do you get with:
=RCHGetElementNumber("GOOG",8011)
=smfGetAData(1,1)
On Sat, Aug 17, 2013 at 12:36 PM, kkkutty <kkkutty@...
<kkkutty@yahoo.com >>wrote:
> I apologize about the spam issue. If it happens again I can login with a
> new email account.
>
> Quick question...I'm still unable to extract the last 20 quarters of
> financial data from AdvFN even with the "ih" fix. For example when I enter
> RCHGetElementNumber("GOOG";, 8006), I get "2013/03". And when I enter
> RCHGetElementNumber("GOOG";, 8010), I also get "2013/03". My SMF Add-in
> folder is located in the C:\program files\ folder (I'm not sure why that
> is)instead of C:\, but that should not make a difference, right? Any idea
> of how I can resolve this issue? Thanks in advance for your input.
>
to be in that same folder.
OK, try this:
1. Close down all open workbooks
2. Open a new workbook
3. Run the smfForceRecalculati
Now, what do you get with:
=RCHGetElementNumbe
=smfGetAData(
On Sat, Aug 17, 2013 at 12:36 PM, kkkutty <kkkutty@
<kkkutty@yahoo.
> I apologize about the spam issue. If it happens again I can login with a
> new email account.
>
> Quick question...I&#
> financial data from AdvFN even with the "ih" fix. For example when I enter
> RCHGetElementNumber
> RCHGetElementNumber
> folder is located in the C:\program files\ folder (I'm not sure why that
> is)instead of C:\, but that should not make a difference, right? Any idea
> of how I can resolve this issue? Thanks in advance for your input.
>
Sat Aug 17, 2013 11:28 pm (PDT) . Posted by:
"kkkutty" kkkutty
I get "2013/03" for the first one and "0:http://www.advfn.com/p.php?pid=financials&symbol=GOOG&mode=quarterly_reports " for the second one.
Even after running smfforcerecalculation, I'm having the same issues (unable to extract previous 20 quarters) with my spreadsheet. Any thoughts? Much appreciated as always. Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Where the add-in is located makes no difference. But the prefix file needs
> to be in that same folder.
>
> OK, try this:
>
> 1. Close down all open workbooks
> 2. Open a new workbook
> 3. Run the smfForceRecalculation macro
>
> Now, what do you get with:
>
> =RCHGetElementNumber("GOOG",8011)
>
> =smfGetAData(1,1)
>
> On Sat, Aug 17, 2013 at 12:36 PM, kkkutty <kkkutty@
> <kkkutty@...>>wrote:
>
> > I apologize about the spam issue. If it happens again I can login with a
> > new email account.
> >
> > Quick question...I'm still unable to extract the last 20 quarters of
> > financial data from AdvFN even with the "ih" fix. For example when I enter
> > RCHGetElementNumber("GOOG";, 8006), I get "2013/03". And when I enter
> > RCHGetElementNumber("GOOG";, 8010), I also get "2013/03". My SMF Add-in
> > folder is located in the C:\program files\ folder (I'm not sure why that
> > is)instead of C:\, but that should not make a difference, right? Any idea
> > of how I can resolve this issue? Thanks in advance for your input.
> >
>
Even after running smfforcerecalculati
--- In smf_addin@yahoogrou
>
> Where the add-in is located makes no difference. But the prefix file needs
> to be in that same folder.
>
> OK, try this:
>
> 1. Close down all open workbooks
> 2. Open a new workbook
> 3. Run the smfForceRecalculati
>
> Now, what do you get with:
>
> =RCHGetElementNumbe
>
> =smfGetAData(
>
> On Sat, Aug 17, 2013 at 12:36 PM, kkkutty <kkkutty@
> <kkkutty@
>
> > I apologize about the spam issue. If it happens again I can login with a
> > new email account.
> >
> > Quick question...I&#
> > financial data from AdvFN even with the "ih" fix. For example when I enter
> > RCHGetElementNumber
> > RCHGetElementNumber
> > folder is located in the C:\program files\ folder (I'm not sure why that
> > is)instead of C:\, but that should not make a difference, right? Any idea
> > of how I can resolve this issue? Thanks in advance for your input.
> >
>
Sat Aug 17, 2013 11:33 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in is not picking up the "ih" from the external file. Note the URL
from the second formula I gave you says "www.advfn.com" below. If the
add-in had picked up the "ih" properly, it should be "ih.advfn.com". My
results for that second formula are:
0:
http://ih.advfn.com/p.php?pid=financials&symbol=GOOG&mode=quarterly_reports
What version of the add-in are you using?
=RCHGetElementNumber("Version")
On Sat, Aug 17, 2013 at 11:28 PM, kkkutty <kkkutty@yahoo.com > wrote:
> I get "2013/03" for the first one and "0:
> http://www.advfn.com/p.php?pid=financials&symbol=GOOG&mode=quarterly_reports "
> for the second one.
>
> Even after running smfforcerecalculation, I'm having the same issues
> (unable to extract previous 20 quarters) with my spreadsheet. Any
> thoughts? Much appreciated as always. Thanks.
>
from the second formula I gave you says "www.advfn.
add-in had picked up the "ih" properly, it should be "ih.advfn.
results for that second formula are:
0:
http://ih.advfn.
What version of the add-in are you using?
=RCHGetElementNumbe
On Sat, Aug 17, 2013 at 11:28 PM, kkkutty <kkkutty@yahoo.
> I get "2013/03" for the first one and "0:
> http://www.advfn.
> for the second one.
>
> Even after running smfforcerecalculati
> (unable to extract previous 20 quarters) with my spreadsheet. Any
> thoughts? Much appreciated as always. Thanks.
>
Sat Aug 17, 2013 11:52 pm (PDT) . Posted by:
"kkkutty" kkkutty
The version I get is "Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files\SMF Add-in; 1)"
I haven't checked for new updates for awhile. I take it I have an older version, right?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The add-in is not picking up the "ih" from the external file. Note the URL
> from the second formula I gave you says "www.advfn.com" below. If the
> add-in had picked up the "ih" properly, it should be "ih.advfn.com". My
> results for that second formula are:
>
> 0:
> http://ih.advfn.com/p.php?pid=financials&symbol=GOOG&mode=quarterly_reports
>
> What version of the add-in are you using?
>
> =RCHGetElementNumber("Version")
>
> On Sat, Aug 17, 2013 at 11:28 PM, kkkutty <kkkutty@...> wrote:
>
> > I get "2013/03" for the first one and "0:
> > http://www.advfn.com/p.php?pid=financials&symbol=GOOG&mode=quarterly_reports "
> > for the second one.
> >
> > Even after running smfforcerecalculation, I'm having the same issues
> > (unable to extract previous 20 quarters) with my spreadsheet. Any
> > thoughts? Much appreciated as always. Thanks.
> >
>
I haven't checked for new updates for awhile. I take it I have an older version, right?
--- In smf_addin@yahoogrou
>
> The add-in is not picking up the "ih" from the external file. Note the URL
> from the second formula I gave you says "www.advfn.
> add-in had picked up the "ih" properly, it should be "ih.advfn.
> results for that second formula are:
>
> 0:
> http://ih.advfn.
>
> What version of the add-in are you using?
>
> =RCHGetElementNumbe
>
> On Sat, Aug 17, 2013 at 11:28 PM, kkkutty <kkkutty@
>
> > I get "2013/03" for the first one and "0:
> > http://www.advfn.
> > for the second one.
> >
> > Even after running smfforcerecalculati
> > (unable to extract previous 20 quarters) with my spreadsheet. Any
> > thoughts? Much appreciated as always. Thanks.
> >
>
Sun Aug 18, 2013 12:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yup. That version doesn't have the ability to pull in the prefix from the
external file. It was actually the first thing I added after that release
went out.
On Sat, Aug 17, 2013 at 11:52 PM, kkkutty <kkkutty@yahoo.com > wrote:
> The version I get is "Stock Market Functions add-in, Version
> 2.1.2012.02.02 (C:\Program Files\SMF Add-in; 1)"
>
> I haven't checked for new updates for awhile. I take it I have an older
> version, right?
>
external file. It was actually the first thing I added after that release
went out.
On Sat, Aug 17, 2013 at 11:52 PM, kkkutty <kkkutty@yahoo.
> The version I get is "Stock Market Functions add-in, Version
> 2.1.2012.02.
>
> I haven't checked for new updates for awhile. I take it I have an older
> version, right?
>
Sun Aug 18, 2013 12:18 am (PDT) . Posted by:
"kkkutty" kkkutty
The new version worked! Many thanks again for your timely responses. Hopefully AdvFN will be updating their quarterly reports soon. Otherwise I'll have to consider other options.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Yup. That version doesn't have the ability to pull in the prefix from the
> external file. It was actually the first thing I added after that release
> went out.
>
> On Sat, Aug 17, 2013 at 11:52 PM, kkkutty <kkkutty@...> wrote:
>
> > The version I get is "Stock Market Functions add-in, Version
> > 2.1.2012.02.02 (C:\Program Files\SMF Add-in; 1)"
> >
> > I haven't checked for new updates for awhile. I take it I have an older
> > version, right?
> >
>
--- In smf_addin@yahoogrou
>
> Yup. That version doesn't have the ability to pull in the prefix from the
> external file. It was actually the first thing I added after that release
> went out.
>
> On Sat, Aug 17, 2013 at 11:52 PM, kkkutty <kkkutty@
>
> > The version I get is "Stock Market Functions add-in, Version
> > 2.1.2012.02.
> >
> > I haven't checked for new updates for awhile. I take it I have an older
> > version, right?
> >
>
Sat Aug 17, 2013 12:38 pm (PDT) . Posted by:
"Regie" gawaine43
I believe there is a hard limit of 500 stocks you can grab at a time from Zacks with the macro before you need to reboot your computer. If you go over, you won't be able to even browse their site. This "throttling" is at the IP level, meaning all your browsers can't connect. The IP ban may last from hours to several months.
Tidak ada komentar:
Posting Komentar