13 New Messages
Digest #2784
Messages
Tue Sep 24, 2013 8:44 am (PDT) . Posted by:
lawrence.leesh
Hi Randy
Could you pls give me the formula to extract EPS (Basic) from
http://www.marketwa
<http://www.marketwa
thanks
LL
Tue Sep 24, 2013 8:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nothing special:
=RCHGetTableCell("http://www.marketwatch.com/investing/Stock/ASII/financials",1,"EPS
(Basic)")
On Tue, Sep 24, 2013 at 8:44 AM, <lawrence.leesh@yahoo.com> wrote:
> Could you pls give me the formula to extract EPS (Basic) from
> http://www.marketwatch.com/investing/Stock/ASII/financials?
>
=RCHGetTableCell(
(Basic)"
On Tue, Sep 24, 2013 at 8:44 AM, <lawrence.leesh@
> Could you pls give me the formula to extract EPS (Basic) from
> http://www.marketwa
>
Tue Sep 24, 2013 1:15 pm (PDT) . Posted by:
lawrence.leesh
Thanks Randy.
---In smf_addin@yahoogrou
wrote:
Nothing special:
=RCHGetTableCell(
/financials
<http://www.marketwa
",1,"
On Tue, Sep 24, 2013 at 8:44 AM, <lawrence.
<mailto:lawrence
Could you pls give me the formula to extract EPS (Basic) from
http://www.marketwa
<http://www.marketwa
Tue Sep 24, 2013 2:40 pm (PDT) . Posted by:
yellowdistiler
On Monday Sep 23, 2013 I was running an update on moving averages
from www.barchart.
of the process I kept getting "Error" values. I checked and this
occurred for RCHGetElementNumber
1146--1284 for all stock symbols I tried, even ones that had
worked just minutes before. I am using Windows XP, Excel 2000,
and the most current SMF version. My internet connection is OK.
I then tried going directly to the barchart web sites. It seems
something has changed on www.barchart.
addresses used by RCHGetElementNumber
blocking IPs. I get the web page that shows the message at the
end of this reply. That explains why I keep getting "Error" when
attempting to retrieve data from any "barchart"
get all "Error"
Have others had this problem beginning Sep 23, 2013? Is there a
workaround that anyone has found?
------------
Forbidden
You don't have permission to access /error/noindex.
server.
Apache/2.2.23 (Amazon) mod_ssl/2.2.
PHP/5.3.20 Server at www.barchart.
---In smf_addin@yahoogrou
wrote:
Randy, can you checkout the failing template?
I just downloaded 2 Barchart templates from the Templates and
example folder.
The Momentum template returns error in every cell.
Error
NYSE
Nasdaq
AMEX
OTCBB
Advancing Issues:
Error
Error
Error
Error
Declining Issues:
Error
Error
Error
Error
Unchanged Issues:
Error
Error
Error
Error
Advancing Shares:
Error
Error
Error
Error
Declining Shares:
Error
Error
Error
Error
Unchanged Shares:
Error
Error
Error
Error
New Highs:
Error
Error
Error
Error
New Lows:
Error
Error
Error
Error
Content of first error cell is
=RCHGetElementNumbe
The technical-indicator template works without errors.
SMF-Template-
<http://f1.grp.
3pLAAvYluriYmPBu1V2
plates%20and%
>
And
SMF-Template-
<http://f1.grp.
ISgScNfQDTogVxt2QVu
plates%20and%
s.xls>
Tue Sep 24, 2013 2:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried these templates:
SMF-Template-Barchart-Market-Momentum.xls
SMF-Template-Barchart-Technical-Indicators.xls
....and both worked fine for me. Their source pages, similar to:
http://www.barchart.com/opinions/stocks/MMM
http://www.barchart.com/stocks/momentum.php
...both work fine for me in FireFox as well.
Were you using the add-in to access a large number of web pages on their
site? I don't know if they are blocking you or not. Can you access their
home page?
On Tue, Sep 24, 2013 at 2:06 PM, <yellowdistiler@yahoo.com> wrote:
> On Monday Sep 23, 2013 I was running an update on moving averages from
> www.barchart.com and it was working fine until in the middle of the
> process I kept getting "Error" values. I checked and this occurred for
> RCHGetElementNumber() numbers 701--717 and 1146--1284 for all stock symbols
> I tried, even ones that had worked just minutes before. I am using Windows
> XP, Excel 2000, and the most current SMF version. My internet connection
> is OK.
>
> I then tried going directly to the barchart web sites. It seems something
> has changed on www.barchart.com (I also tried the addresses used by
> RCHGetElementNumber()) or perhaps they are blocking IPs. I get the web
> page that shows the message at the end of this reply. That explains why I
> keep getting "Error" when attempting to retrieve data from any "barchart";
> web site. I also get all "Error"s from all the Barchart templates.
>
> Have others had this problem beginning Sep 23, 2013? Is there a
> workaround that anyone has found?
>
SMF-Template-
SMF-Template-
....and both worked fine for me. Their source pages, similar to:
http://www.barchart
http://www.barchart
...both work fine for me in FireFox as well.
Were you using the add-in to access a large number of web pages on their
site? I don't know if they are blocking you or not. Can you access their
home page?
On Tue, Sep 24, 2013 at 2:06 PM, <yellowdistiler@
> On Monday Sep 23, 2013 I was running an update on moving averages from
> www.barchart.
> process I kept getting "Error" values. I checked and this occurred for
> RCHGetElementNumber
> I tried, even ones that had worked just minutes before. I am using Windows
> XP, Excel 2000, and the most current SMF version. My internet connection
> is OK.
>
> I then tried going directly to the barchart web sites. It seems something
> has changed on www.barchart.
> RCHGetElementNumber
> page that shows the message at the end of this reply. That explains why I
> keep getting "Error" when attempting to retrieve data from any "barchart"
> web site. I also get all "Error"
>
> Have others had this problem beginning Sep 23, 2013? Is there a
> workaround that anyone has found?
>
Tue Sep 24, 2013 5:43 pm (PDT) . Posted by:
yellowdistiler
I just tried again using your links via the internet or with the
SMF function and still get the 403 Forbidden message and "Error"
I had never had a problem downloading moving averages for a
greater number of stocks with the same spreadsheet from their
site (I think all the moving averages for a stock are on a single
web page). I only renew them every few months.
Since others can access the site I'll have to presume that my IP
is blocked. I'll try again in a week or so and use other sources
for now. If I get back on their site, I will limit the number of
stocks accessed at any one time. I don't know if this is
peculiar for barchart.com to block access. The same number of
stocks has run fine on every other site I use for over 5 years.
But...things change...
---In smf_addin@yahoogrou
wrote:
I just tried these templates:
SMF-Template-
SMF-Template-
....and both worked fine for me. Their source pages, similar to:
http://www.barchart
<http://www.barchart
http://www.barchart
<http://www.barchart
...both work fine for me in FireFox as well.
Were you using the add-in to access a large number of web pages
on their site? I don't know if they are blocking you or not. Can
you access their home page?
On Tue, Sep 24, 2013 at 2:06 PM, <yellowdistiler@
<mailto:yellowdi
On Monday Sep 23, 2013 I was running an update on moving averages
from www.barchart.
working fine until in the middle of the process I kept getting
"Error" values. I checked and this occurred for
RCHGetElementNumber
stock symbols I tried, even ones that had worked just minutes
before. I am using Windows XP, Excel 2000, and the most current
SMF version. My internet connection is OK.
I then tried going directly to the barchart web sites. It seems
something has changed on www.barchart.
<http://www.barchart
RCHGetElementNumber
the web page that shows the message at the end of this reply.
That explains why I keep getting "Error" when attempting to
retrieve data from any "barchart"
"Error"
Have others had this problem beginning Sep 23, 2013? Is there a
workaround that anyone has found?
Tue Sep 24, 2013 6:05 pm (PDT) . Posted by:
yellowdistiler
I did get access to barchart.com&#
http://realtime.
"You may not use any data mining, robots, or similar data
gathering and extraction tools on the Content"
Perhaps my access with SMF was interpreted as a robot and my IP
was blocked. It seems use of SMF for access to their site may
have to be limited so as not to appear as a robot. I have no
idea what their limits or algorithms may be in making that
decision. But if one is accessing their site with SMF, it seems
you may have to be frugal in using it.
If Kermit W. Prather in the original message used the technical
template first it probably worked. But then using the other
templates a short time later triggered the "robot" algorithm. If
he had not accessed barchart.com before using the templates, then
it seems that the threshold may not be very high for being id'd
as a robot. It would be interesting to see if Kermit can access
barchart.com with a browser if the "Error" is still being
returned for the templates.
---In smf_addin@yahoogrou
wrote:
I just tried again using your links via the internet or with the
SMF function and still get the 403 Forbidden message and "Error"
I had never had a problem downloading moving averages for a
greater number of stocks with the same spreadsheet from their
site (I think all the moving averages for a stock are on a single
web page). I only renew them every few months.
Since others can access the site I'll have to presume that my IP
is blocked. I'll try again in a week or so and use other sources
for now. If I get back on their site, I will limit the number of
stocks accessed at any one time. I don't know if this is
peculiar for barchart.com to block access. The same number of
stocks has run fine on every other site I use for over 5 years.
But...things change...
---In smf_addin@yahoogrou
wrote:
I just tried these templates:
SMF-Template-
SMF-Template-
....and both worked fine for me. Their source pages, similar to:
http://www.barchart
<http://www.barchart
http://www.barchart
<http://www.barchart
...both work fine for me in FireFox as well.
Were you using the add-in to access a large number of web pages
on their site? I don't know if they are blocking you or not. Can
you access their home page?
On Tue, Sep 24, 2013 at 2:06 PM, <yellowdistiler@
<mailto:yellowdi
On Monday Sep 23, 2013 I was running an update on moving averages
from www.barchart.
working fine until in the middle of the process I kept getting
"Error" values. I checked and this occurred for
RCHGetElementNumber
stock symbols I tried, even ones that had worked just minutes
before. I am using Windows XP, Excel 2000, and the most current
SMF version. My internet connection is OK.
I then tried going directly to the barchart web sites. It seems
something has changed on www.barchart.
<http://www.barchart
RCHGetElementNumber
the web page that shows the message at the end of this reply.
That explains why I keep getting "Error" when attempting to
retrieve data from any "barchart"
"Error"
Have others had this problem beginning Sep 23, 2013? Is there a
workaround that anyone has found?
Tue Sep 24, 2013 3:49 pm (PDT) . Posted by:
kkkutty
Hey ML, thanks a lot for your different attempt. Just a quick
question on your template....
For example, I tried to pull 20 quarters of data for LQDT and
INWK. Both of those companies have the "mm" and "inc" issues in
the URL. If the URL is not correct, it looks like it defaults to
the non-full history site so I'm only able to pull the last 4
quarters. Any help would be much appreciated. Thanks again for
all your efforts!
kk
---In smf_addin@yahoogrou
wrote:
The "Upload by Members" section now has my attempt at working
with ADVFN's new website and data. It has data for the trailing
12 quarters as well as the last 10 years. It shouldn'
hard to adjust if you want more or less quarterly or annual data.
Teasing the exchange and the company name ADVFN uses in the URL
from the smfGetWebPage function took an obnoxious amount of text
parsing. In the end, I had to set up an exceptions table for
when the parsing just didn't provide the correct company name.
Its not elegant, but its not overly burdensome, either. On the
other hand, every single bit of data is pulled using the
RCHGetTableCell function, so any recalculations take a bit to
complete. Those with older computers beware??
Tue Sep 24, 2013 6:55 pm (PDT) . Posted by:
dcharlotte99
Thanks much its working I fixed thru Data-Edit Links. I hadn't
known how to do that.
---In smf_addin@yahoogrou
wrote:
If you saw a location in front of the function, adding the add-in
to that location doesn't help. You have to resolve the link
errors before it can do the recalculation you need.
Check the "Location errors" item in the LINKS area of the Yahoo
group. Or try just running the smfFixLinks macro that is part of
the add-in.
On Sat, Sep 21, 2013 at 7:20 PM, Deborah <dcharlotte99@
<mailto:dcharlot
First, my thanks to John Babcock for the new ADVFN 10-yr
financial spreadsheet that works with the changes to the ADVFN
website. It will be a lifesaver once I get it to update.
That's my problem, the spreadsheet won't recalculate when I enter
a new ticker.
F9 changes the company and exchange info cells as well as the URL
cells John includes. But all the data is $0.00. There are no
error codes.
I noticed the spreadsheet uses C:/SMF for the Add-in location, I
created that. I've had the add-in installed at C:/Program
Files/SMF Add-in for several years. I made sure the Add-in is
active in the Excel Options.
Any clues why the data doesn't update?
Tue Sep 24, 2013 7:16 pm (PDT) . Posted by:
dcharlotte99
My ADVFN spreadsheet is updating correctly with one exception.
Data for about 10 rows for year 2003 (column B) was not updating
until I removed the phrase '.value' from within the formula. You
can look at the other yearly columns to see the error.
---In smf_addin@yahoogroups.com, <dcharlotte99@...> wrote:
Thanks much its working I fixed thru Data-Edit Links. I hadn't
known how to do that.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com>
wrote:
If you saw a location in front of the function, adding the add-in
to that location doesn't help. You have to resolve the link
errors before it can do the recalculation you need.
Check the "Location errors" item in the LINKS area of the Yahoo
group. Or try just running the smfFixLinks macro that is part of
the add-in.
On Sat, Sep 21, 2013 at 7:20 PM, Deborah <dcharlotte99@...
<mailto:dcharlotte99@...> > wrote:
First, my thanks to John Babcock for the new ADVFN 10-yr
financial spreadsheet that works with the changes to the ADVFN
website. It will be a lifesaver once I get it to update.
That's my problem, the spreadsheet won't recalculate when I enter
a new ticker.
F9 changes the company and exchange info cells as well as the URL
cells John includes. But all the data is $0.00. There are no
error codes.
I noticed the spreadsheet uses C:/SMF for the Add-in location, I
created that. I've had the add-in installed at C:/Program
Files/SMF Add-in for several years. I made sure the Add-in is
active in the Excel Options.
Any clues why the data doesn't update?
Data for about 10 rows for year 2003 (column B) was not updating
until I removed the phrase '.value&#
can look at the other yearly columns to see the error.
---In smf_addin@yahoogrou
Thanks much its working I fixed thru Data-Edit Links. I hadn't
known how to do that.
---In smf_addin@yahoogrou
wrote:
If you saw a location in front of the function, adding the add-in
to that location doesn't help. You have to resolve the link
errors before it can do the recalculation you need.
Check the "Location errors" item in the LINKS area of the Yahoo
group. Or try just running the smfFixLinks macro that is part of
the add-in.
On Sat, Sep 21, 2013 at 7:20 PM, Deborah <dcharlotte99@
<mailto:dcharlot
First, my thanks to John Babcock for the new ADVFN 10-yr
financial spreadsheet that works with the changes to the ADVFN
website. It will be a lifesaver once I get it to update.
That's my problem, the spreadsheet won't recalculate when I enter
a new ticker.
F9 changes the company and exchange info cells as well as the URL
cells John includes. But all the data is $0.00. There are no
error codes.
I noticed the spreadsheet uses C:/SMF for the Add-in location, I
created that. I've had the add-in installed at C:/Program
Files/SMF Add-in for several years. I made sure the Add-in is
active in the Excel Options.
Any clues why the data doesn't update?
Tue Sep 24, 2013 7:43 pm (PDT) . Posted by:
derrickhnj
Anyone having trouble with this model lately? It was working
fine for me just yesterday and today it is not pulling in any
amounts. My sheet is on auto calculate and the addin is
correctly installed because I'm also pulling MSN data. Just
don't know what's happening.
---In smf_addin@yahoogrou
Thank you for sharing this model with us, much appreciated.
--- In smf_addin@yahoogrou
Oops!! My fault. I only saw a few years of data for ticker FB
(FaceBook) because there ARE only a few years of data. When I
substituted another ticker, XOM (ExxonMobil) and hit F9, all 10
years of data appeared.
Thanks for such a useful spreadsheet!
Toby
Tue Sep 24, 2013 7:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I try to go to gurufocus.com right now, it tells me the website is
down.
Verified by: http://www.isitdownrightnow.com/gurufocus.com.html
On Tue, Sep 24, 2013 at 7:41 PM, <derrickhorvath@gmail.com> wrote:
> Anyone having trouble with this model lately? It was working fine for me
> just yesterday and today it is not pulling in any amounts. My sheet is on
> auto calculate and the addin is correctly installed because I'm also
> pulling MSN data. Just don't know what's happening.
>
down.
Verified by: http://www.isitdown
On Tue, Sep 24, 2013 at 7:41 PM, <derrickhorvath@
> Anyone having trouble with this model lately? It was working fine for me
> just yesterday and today it is not pulling in any amounts. My sheet is on
> auto calculate and the addin is correctly installed because I'm also
> pulling MSN data. Just don't know what's happening.
>
Tue Sep 24, 2013 8:17 pm (PDT) . Posted by:
dcharlotte99
Thanks I was wondering why the gurufocus 10-year spreadsheet
wasn't updating.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
When I try to go to gurufocus.com <http://gurufocus.com> right
now, it tells me the website is down.
Verified by: http://www.isitdownrightnow.com/gurufocus.com.html
<http://www.isitdownrightnow.com/gurufocus.com.html>
On Tue, Sep 24, 2013 at 7:41 PM, <derrickhorvath@...
<mailto:derrickhorvath@...> > wrote:
Anyone having trouble with this model lately? It was working
fine for me just yesterday and today it is not pulling in any
amounts. My sheet is on auto calculate and the addin is
correctly installed because I'm also pulling MSN data. Just
don't know what's happening.
wasn't updating.
---In smf_addin@yahoogrou
When I try to go to gurufocus.com <http://gurufocus.
now, it tells me the website is down.
Verified by: http://www.isitdown
<http://www.isitdown
On Tue, Sep 24, 2013 at 7:41 PM, <derrickhorvath@
<mailto:derrickh
Anyone having trouble with this model lately? It was working
fine for me just yesterday and today it is not pulling in any
amounts. My sheet is on auto calculate and the addin is
correctly installed because I'm also pulling MSN data. Just
don't know what's happening.
Tidak ada komentar:
Posting Komentar