12 New Messages
Digest #2744
Messages
Sat Aug 24, 2013 2:29 am (PDT) . Posted by:
sma11dragon
Hi Randy,
I encountered similar problem in this tread. It works for most
stock tickers but I occasionally found ERROR on other stock
tickers. For example, stock tickers like CHK, AZN, MSI, and STRA
do not work for me. I remember I have been able to load the
financial data on these companies before but somehow it stopped
working for me. I tried running the smfForceRecalculati
but it didn't work anyway. The funny thing is that
=RCHGetElementNumbe
works but all other elements return ERROR.
Appreciate your help on what's wrong.
--- In smf_addin@yahoogrou
Thanks Randy. This works like a charm!
--- In smf_addin@yahoogrou
<rharmelink@
>
> That's because you have a CSX and WAG on the London Stock
Exchange, which
> is what the "uk" website will default to when no stock exchange
is cited.
> If you're after U.S. stocks, you should always use the exchange
prefix when
> using the "uk" website. So, try NYSE:CSX and NYSE:WAG as your
ticker
> symbols.
>
> On Fri, Aug 2, 2013 at 11:21 PM, ajtalukdar <ajtalukdar@
wrote:
>
> > Applying the UK prefix fix works, however only partly. Now I
find that
> >
> > the following calls work
> > RCHGetElementNumber
> > RCHGetElementNumber
> >
> > while the following DO NOT work - returning Error
> > RCHGetElementNumber
> > RCHGetElementNumber
> >
> > Any ideas why some stock codes are working while others are
not?
> >
>
Sat Aug 24, 2013 2:37 am (PDT) . Posted by:
sma11dragon
Hi Randy,
I forgot to mention that when I add the stock market exchange
prefix (for example, NYSE:MSI), all the financial information
using RCHGetElementNumber
RCHGetElementNumber
returns ERROR and $-, respectively. Hope you have enough
information to help out.
--- In smf_addin@yahoogrou
Hi Randy,
I encountered similar problem in this tread. It works for most
stock tickers but I occasionally found ERROR on other stock
tickers. For example, stock tickers like CHK, AZN, MSI, and STRA
do not work for me. I remember I have been able to load the
financial data on these companies before but somehow it stopped
working for me. I tried running the smfForceRecalculati
but it didn't work anyway. The funny thing is that
=RCHGetElementNumbe
works but all other elements return ERROR.
Appreciate your help on what's wrong.
--- In smf_addin@yahoogrou
Thanks Randy. This works like a charm!
--- In smf_addin@yahoogrou
<rharmelink@
>
> That's because you have a CSX and WAG on the London Stock
Exchange, which
> is what the "uk" website will default to when no stock exchange
is cited.
> If you're after U.S. stocks, you should always use the exchange
prefix when
> using the "uk" website. So, try NYSE:CSX and NYSE:WAG as your
ticker
> symbols.
>
> On Fri, Aug 2, 2013 at 11:21 PM, ajtalukdar <ajtalukdar@
wrote:
>
> > Applying the UK prefix fix works, however only partly. Now I
find that
> >
> > the following calls work
> > RCHGetElementNumber
> > RCHGetElementNumber
> >
> > while the following DO NOT work - returning Error
> > RCHGetElementNumber
> > RCHGetElementNumber
> >
> > Any ideas why some stock codes are working while others are
not?
> >
>
Sat Aug 24, 2013 3:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
So, you're telling me that:
=RCHGetElementNumber("AZN";,1)
...works, but the following returns "Error"??
=RCHGetElementNumber("AZN";,3)
What version of the add-in are you using:
=RCHGetElementNumber("Version")
On Sat, Aug 24, 2013 at 2:29 AM, <sma11dragon@yahoo.com > wrote:
> I encountered similar problem in this tread. It works for most stock
> tickers but I occasionally found ERROR on other stock tickers. For example,
> stock tickers like CHK, AZN, MSI, and STRA do not work for me. I remember I
> have been able to load the financial data on these companies before but
> somehow it stopped working for me. I tried running the
> smfForceRecalculation macro but it didn't work anyway. The funny thing is
> that =RCHGetElementNumber(TICKER,1) to fet the company's description works
> but all other elements return ERROR.
>
> Appreciate your help on what's wrong.
>
=RCHGetElementNumbe
...works, but the following returns "Error"
=RCHGetElementNumbe
What version of the add-in are you using:
=RCHGetElementNumbe
On Sat, Aug 24, 2013 at 2:29 AM, <sma11dragon@
> I encountered similar problem in this tread. It works for most stock
> tickers but I occasionally found ERROR on other stock tickers. For example,
> stock tickers like CHK, AZN, MSI, and STRA do not work for me. I remember I
> have been able to load the financial data on these companies before but
> somehow it stopped working for me. I tried running the
> smfForceRecalculati
> that =RCHGetElementNumbe
> but all other elements return ERROR.
>
> Appreciate your help on what's wrong.
>
Sat Aug 24, 2013 4:45 am (PDT) . Posted by:
sma11dragon
Hi Randy,
I am using Stock Market Functions add-in, Version 2.1.2012.12.
(C:\Program Files\SMF Add-in; 1).
Not all of the =RCHGetElementNumbe
example, =RCHGetElementNumbe
Exchange but I have ERROR return sporadically at element #27 -
#32, #35, #36, and all of the elements from AdvFn starting from
element #5196.
--- In smf_addin@yahoogrou
So, you're telling me that:
=RCHGetElementNumbe
...works, but the following returns "Error"
=RCHGetElementNumbe
What version of the add-in are you using:
=RCHGetElementNumbe
On Sat, Aug 24, 2013 at 2:29 AM, <sma11dragon@
I encountered similar problem in this tread. It works for most
stock tickers but I occasionally found ERROR on other stock
tickers. For example, stock tickers like CHK, AZN, MSI, and STRA
do not work for me. I remember I have been able to load the
financial data on these companies before but somehow it stopped
working for me. I tried running the smfForceRecalculati
but it didn't work anyway. The funny thing is that
=RCHGetElementNumbe
works but all other elements return ERROR.
Appreciate your help on what's wrong.
Sat Aug 24, 2013 5:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, you originally said all elements except #1 returned error. Sigh.
As previously noted, #27-#32 and #35-#36 are now obsolete. When MSN
redesigned their web page layouts (again) this year, they dropped those
elements. See this thread:
http://finance.groups.yahoo.com/group/smf_addin/message/22689
All AdvFN elements are currently in flux, because AdvFN appears to be in
the midst of a major update of their web site. As a temporary work-around,
I changed my prefix to "ih", but I don't know how long that will work
either because I've seen a beta version of the updates for that version of
their site as well. See this thread:
http://finance.groups.yahoo.com/group/smf_addin/message/23309
On Sat, Aug 24, 2013 at 4:45 AM, <sma11dragon@yahoo.com > wrote:
> Not all of the =RCHGetElementNumber(TICKER, #) returns ERROR. For
> example, =RCHGetElementNumber("AZN";,3) returns New York Stock Exchange
> but I have ERROR return sporadically at element #27 - #32, #35, #36, and
> all of the elements from AdvFn starting from element #5196.
>
As previously noted, #27-#32 and #35-#36 are now obsolete. When MSN
redesigned their web page layouts (again) this year, they dropped those
elements. See this thread:
http://finance.
All AdvFN elements are currently in flux, because AdvFN appears to be in
the midst of a major update of their web site. As a temporary work-around,
I changed my prefix to "ih"
either because I've seen a beta version of the updates for that version of
their site as well. See this thread:
http://finance.
On Sat, Aug 24, 2013 at 4:45 AM, <sma11dragon@
> Not all of the =RCHGetElementNumbe
> example, =RCHGetElementNumbe
> but I have ERROR return sporadically at element #27 - #32, #35, #36, and
> all of the elements from AdvFn starting from element #5196.
>
Sat Aug 24, 2013 7:09 pm (PDT) . Posted by:
"cs.holdings" cs.holdings
Randy,
Is there a way to run a similar loop for =RCHGetElementNumber(A1:A3,5296)?
'Sub Test()
' Dim sItems As String
' Dim oCell As Range
' sItems = "D"
' For Each oCell In [B4:Z4]
' If oCell.Value2 = "" Then Exit For
' Range(oCell.Offset(1, 0), oCell.Offset(1350, 0)) = RCHGetYahooHistory(oCell.Value2, pResort:=1, pItems:=sItems, pDim1:=1350, pDim2:=1)
' sItems = "A"
' Next oCell
' End Sub
Is there a way to run a similar loop for =RCHGetElementNumbe
'Sub Test()
' Dim sItems As String
' Dim oCell As Range
' sItems = "D"
' For Each oCell In [B4:Z4]
' If oCell.Value2 = "" Then Exit For
' Range(oCell.
' sItems = "A"
' Next oCell
' End Sub
Sat Aug 24, 2013 7:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just use the smfUpdateDownloadTable process. See the LINKS area of the
group for more info.
On Sat, Aug 24, 2013 at 7:09 PM, cs.holdings <pc_babe@msn.com > wrote:
>
> Is there a way to run a similar loop for =RCHGetElementNumber(A1:A3,5296)?
>
> 'Sub Test()
> ' Dim sItems As String
> ' Dim oCell As Range
> ' sItems = "D"
> ' For Each oCell In [B4:Z4]
> ' If oCell.Value2 = "" Then Exit For
> ' Range(oCell.Offset(1, 0), oCell.Offset(1350, 0)) =
> RCHGetYahooHistory(oCell.Value2, pResort:=1, pItems:=sItems, pDim1:=1350,
> pDim2:=1)
> ' sItems = "A"
> ' Next oCell
> ' End Sub
>
group for more info.
On Sat, Aug 24, 2013 at 7:09 PM, cs.holdings <pc_babe@msn.
>
> Is there a way to run a similar loop for =RCHGetElementNumbe
>
> 'Sub Test()
> ' Dim sItems As String
> ' Dim oCell As Range
> ' sItems = "D"
> ' For Each oCell In [B4:Z4]
> ' If oCell.Value2 = "" Then Exit For
> ' Range(oCell.
> RCHGetYahooHistory(
> pDim2:=1)
> ' sItems = "A"
> ' Next oCell
> ' End Sub
>
Sat Aug 24, 2013 8:11 pm (PDT) . Posted by:
"cs.holdings" cs.holdings
OMG ... beautiful. Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just use the smfUpdateDownloadTable process. See the LINKS area of the
> group for more info.
>
> On Sat, Aug 24, 2013 at 7:09 PM, cs.holdings <pc_babe@...> wrote:
>
> >
> > Is there a way to run a similar loop for =RCHGetElementNumber(A1:A3,5296)?
> >
> > 'Sub Test()
> > ' Dim sItems As String
> > ' Dim oCell As Range
> > ' sItems = "D"
> > ' For Each oCell In [B4:Z4]
> > ' If oCell.Value2 = "" Then Exit For
> > ' Range(oCell.Offset(1, 0), oCell.Offset(1350, 0)) =
> > RCHGetYahooHistory(oCell.Value2, pResort:=1, pItems:=sItems, pDim1:=1350,
> > pDim2:=1)
> > ' sItems = "A"
> > ' Next oCell
> > ' End Sub
> >
>
--- In smf_addin@yahoogrou
>
> Just use the smfUpdateDownloadTa
> group for more info.
>
> On Sat, Aug 24, 2013 at 7:09 PM, cs.holdings <pc_babe@
>
> >
> > Is there a way to run a similar loop for =RCHGetElementNumbe
> >
> > 'Sub Test()
> > ' Dim sItems As String
> > ' Dim oCell As Range
> > ' sItems = "D"
> > ' For Each oCell In [B4:Z4]
> > ' If oCell.Value2 = "" Then Exit For
> > ' Range(oCell.
> > RCHGetYahooHistory(
> > pDim2:=1)
> > ' sItems = "A"
> > ' Next oCell
> > ' End Sub
> >
>
Sat Aug 24, 2013 8:38 pm (PDT) . Posted by:
"Philip" mokwit
I got this message
"Error -- Too many web page retrievals"
while attempting to download 3400 names using the yahoo code - occurred at row 989 - may have done test downloads. First time I have done a big download in years and never see before so assume it is a fairly recent restruiction
"Error -- Too many web page retrievals"
Anybody got info on this - i.e. how long it lasts (e.g. 24 hours, what the limit is - I guess 1000)etc.
ANY WORKAROUNDS?
"Error -- Too many web page retrievals"
while attempting to download 3400 names using the yahoo code - occurred at row 989 - may have done test downloads. First time I have done a big download in years and never see before so assume it is a fairly recent restruiction
"Error -- Too many web page retrievals"
Anybody got info on this - i.e. how long it lasts (e.g. 24 hours, what the limit is - I guess 1000)etc.
ANY WORKAROUNDS?
Sat Aug 24, 2013 10:32 pm (PDT) . Posted by:
"Philip" mokwit
Should have added that the data I wanted was 'Company Name' 13863 and Number of shares in free float 982 - can't as yet find alternatives in other data sources such as Reuters or GOOG or AdvFN which was my first thought as to how to work around. This despite the fact that e.g. Float is a e.g. GOOG data field on web site
--- In smf_addin@yahoogroups.com , "Philip" <pmanz@...> wrote:
>
> I got this message
>
> "Error -- Too many web page retrievals"
>
> while attempting to download 3400 names using the yahoo code - occurred at row 989 - may have done test downloads. First time I have done a big download in years and never see before so assume it is a fairly recent restruiction
>
> "Error -- Too many web page retrievals"
>
> Anybody got info on this - i.e. how long it lasts (e.g. 24 hours, what the limit is - I guess 1000)etc.
>
> ANY WORKAROUNDS?
>
--- In smf_addin@yahoogrou
>
> I got this message
>
> "Error -- Too many web page retrievals"
>
> while attempting to download 3400 names using the yahoo code - occurred at row 989 - may have done test downloads. First time I have done a big download in years and never see before so assume it is a fairly recent restruiction
>
> "Error -- Too many web page retrievals"
>
> Anybody got info on this - i.e. how long it lasts (e.g. 24 hours, what the limit is - I guess 1000)etc.
>
> ANY WORKAROUNDS?
>
Sat Aug 24, 2013 11:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Getting data on 3400 companies is NOT what the add-in is designed for. The
method you're using would require accessing data from 3400 web pages, and
the add-in can only do 1000 in a "session". And you should almost NEVER hit
that limit. If you do have a need for so much data, you should be using
paid tools like Portfolio123 or AAII's Stock Investor Pro.
In any case, you should be able to get everything you want from FinViz with
a single Internet access. Check out the FinViz entries in the LINKS area of
the group.
On Sat, Aug 24, 2013 at 10:32 PM, Philip <pmanz@usa.net> wrote:
> Should have added that the data I wanted was 'Company Name' 13863 and
> Number of shares in free float 982 - can't as yet find alternatives in
> other data sources such as Reuters or GOOG or AdvFN which was my first
> thought as to how to work around. This despite the fact that e.g. Float is
> a e.g. GOOG data field on web site
>
> --- In smf_addin@yahoogroups.com , "Philip" <pmanz@...> wrote:
> >
> > I got this message
> >
> > "Error -- Too many web page retrievals"
> >
> > while attempting to download 3400 names using the yahoo code - occurred
> at row 989 - may have done test downloads. First time I have done a big
> download in years and never see before so assume it is a fairly recent
> restruiction
> >
> > "Error -- Too many web page retrievals"
> >
> > Anybody got info on this - i.e. how long it lasts (e.g. 24 hours, what
> the limit is - I guess 1000)etc.
> >
> > ANY WORKAROUNDS?
> >
>
method you're using would require accessing data from 3400 web pages, and
the add-in can only do 1000 in a "session"
that limit. If you do have a need for so much data, you should be using
paid tools like Portfolio123 or AAII's Stock Investor Pro.
In any case, you should be able to get everything you want from FinViz with
a single Internet access. Check out the FinViz entries in the LINKS area of
the group.
On Sat, Aug 24, 2013 at 10:32 PM, Philip <pmanz@usa.net> wrote:
> Should have added that the data I wanted was 'Company Name' 13863 and
> Number of shares in free float 982 - can't as yet find alternatives in
> other data sources such as Reuters or GOOG or AdvFN which was my first
> thought as to how to work around. This despite the fact that e.g. Float is
> a e.g. GOOG data field on web site
>
> --- In smf_addin@yahoogrou
> >
> > I got this message
> >
> > "Error -- Too many web page retrievals"
> >
> > while attempting to download 3400 names using the yahoo code - occurred
> at row 989 - may have done test downloads. First time I have done a big
> download in years and never see before so assume it is a fairly recent
> restruiction
> >
> > "Error -- Too many web page retrievals"
> >
> > Anybody got info on this - i.e. how long it lasts (e.g. 24 hours, what
> the limit is - I guess 1000)etc.
> >
> > ANY WORKAROUNDS?
> >
>
Sat Aug 24, 2013 11:28 pm (PDT) . Posted by:
"Gururaj Rao" gurujapan
In the Links example you have given:
941
RCHGetElementNumber("~~~~~", 941)
RCHGetTableCell("http://finance.yahoo.com/q/ks?s=~~~~~ ",1,">Market Cap")
I'd like to use in.reuters.com to get various data into a table following a
similar approach.
If the ticker name is say WIPR.NS, I presume the five tildes become ~~~~.~~
To access the data here:
http://in.reuters.com/finance/stocks/overview?symbol=WIPR.NS <http://in.finance.yahoo.com/q/ks?s=WIPRO.NS >
The URL up to here is fine; I am stuck after this.
I tried with to get Beta substituting as follows:
RCHGetTableCell("
http://in.reuters.com/finance/stocks/overview?symbol=WIPR.NS <http://in.finance.yahoo.com/q/ks?s=WIPRO.NS >
",1,">Beta:")
assuming 1 indicates the first row.
Where am I going wrong?
How do I modify the parameters after .....s=WIPR.NS" in general to pick up
data from other tables at this site such as those on the right side, namely
P/E (TTM), ROI and so on, and also the data from all tables here:
http://in.reuters.com/finance/stocks/financialHighlights?symbol=WIPR.NS
TIA
Gururaj Rao
941
RCHGetElementNumber
RCHGetTableCell(
I'd like to use in.reuters.com to get various data into a table following a
similar approach.
If the ticker name is say WIPR.NS, I presume the five tildes become ~~~~.~~
To access the data here:
http://in.reuters.
The URL up to here is fine; I am stuck after this.
I tried with to get Beta substituting as follows:
RCHGetTableCell(
http://in.reuters.
",1,"
assuming 1 indicates the first row.
Where am I going wrong?
How do I modify the parameters after .....s=WIPR.
data from other tables at this site such as those on the right side, namely
P/E (TTM), ROI and so on, and also the data from all tables here:
http://in.reuters.
TIA
Gururaj Rao
Tidak ada komentar:
Posting Komentar