15 New Messages
Digest #2629
2b
Re: Getting started and data from other sources to check consistency by "Randy Harmelink" rharmelink
Messages
Thu May 23, 2013 4:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's what I would suggest. Refer them to the web page presentations of
the data...
For example:
http://www.advfn.com/p.php?pid=financials&btn=quarterly_reports&mode=&symbol=NASDAQ%3ADELL
On Thu, May 23, 2013 at 8:52 AM, domellner <dominique.ellner@gmail.com >wrote:
> Thank you. Should I try to alert them to the problem?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > It appears that is what AdvFN has posted...
>
the data...
For example:
http://www.advfn.
On Thu, May 23, 2013 at 8:52 AM, domellner <dominique.ellner@
> Thank you. Should I try to alert them to the problem?
>
> --- In smf_addin@yahoogrou
> >
> > It appears that is what AdvFN has posted...
>
Thu May 23, 2013 5:09 pm (PDT) . Posted by:
"rogacox" rogacox
I have a beginning spreadsheet with errors for the Morningstar column that puzzle me. In addition, since the raw data are inconsistent, is it possible to get some of this data from fidelity, streetinsider, etc. Rankings from various providers may be different based upon population universe, timing of updates, etc. I will try to send the file as an attachment and appreciate any and all help. I am not particularly versed in programming so an instructions/sample lines of code, etc. are appreciated.
Thu May 23, 2013 5:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
One issue with MorningStar is that you do need to visit the site with IE or
the EXCEL Web Query dialog each day before using the website with the
add-in. That's because they do some advertising redirection on your first
visit of the day, so you need something to update a cookie to indicate they
don't need to do the redirection.
On Thu, May 23, 2013 at 5:04 PM, rogacox <rogacox@yahoo.com > wrote:
> I have a beginning spreadsheet with errors for the Morningstar column that
> puzzle me. In addition, since the raw data are inconsistent, is it
> possible to get some of this data from fidelity, streetinsider, etc.
> Rankings from various providers may be different based upon population
> universe, timing of updates, etc. I will try to send the file as an
> attachment and appreciate any and all help. I am not particularly versed
> in programming so an instructions/sample lines of code, etc. are
> appreciated.
>
the EXCEL Web Query dialog each day before using the website with the
add-in. That's because they do some advertising redirection on your first
visit of the day, so you need something to update a cookie to indicate they
don't need to do the redirection.
On Thu, May 23, 2013 at 5:04 PM, rogacox <rogacox@yahoo.
> I have a beginning spreadsheet with errors for the Morningstar column that
> puzzle me. In addition, since the raw data are inconsistent, is it
> possible to get some of this data from fidelity, streetinsider, etc.
> Rankings from various providers may be different based upon population
> universe, timing of updates, etc. I will try to send the file as an
> attachment and appreciate any and all help. I am not particularly versed
> in programming so an instructions/
> appreciated.
>
Thu May 23, 2013 5:14 pm (PDT) . Posted by:
"rogacox" rogacox
I believe I uploaded a file to the addin folder when I was trying to upload a file for review with my message. The file name is Consistency Investment Spreadsheet.
Sorry and Thanks
Sorry and Thanks
Thu May 23, 2013 5:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'd suggest using the smfUpdateDownloadTable for that, so that everything
doesn't need to recalculate every time the workbook is opened...
On Thu, May 23, 2013 at 5:14 PM, rogacox <rogacox@yahoo.com > wrote:
> I believe I uploaded a file to the addin folder when I was trying to
> upload a file for review with my message. The file name is Consistency
> Investment Spreadsheet.
>
> Sorry and Thanks
>
doesn't need to recalculate every time the workbook is opened...
On Thu, May 23, 2013 at 5:14 PM, rogacox <rogacox@yahoo.
> I believe I uploaded a file to the addin folder when I was trying to
> upload a file for review with my message. The file name is Consistency
> Investment Spreadsheet.
>
> Sorry and Thanks
>
Thu May 23, 2013 9:09 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
actually, what I need to extract is only the
EPS ( $) and Dividend per Share ( $)
as it may give varies result depending to what symbols I input
for example
in
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
gives the result of
EPS ( $)
Dividend per Share ( $)
whereas
http://www.4-traders.com/SAIC-MOTOR-CORPORATION-LI-6495767/financials/
gives the result of
EPS ( CNY)
Dividend per Share ( CNY)
that is why i wanted to use codes to extract that
for dividend per share, i used
=RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"Dividend per Share")
and it worked fine
but for
=RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"EPS ")
it gives me an ''ERROR'' message
is there any words i should use?
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's what there are multiple search strings, so that you can position
> yourself better. For example:
>
> =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Finances
> - Leverage",">Finance")
> =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Income
> Statement Data","Yield")
>
> I don't know why you would want to extract the word "Sales", but try this:
>
> =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"Sales";)
>
> On Thu, May 23, 2013 at 9:12 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4traders.com/ "&D2&"/financials/",1,"EBITDA"),"
> > is working
> >
> > but the problem lies with the column ''Finance'' and ''Yield''
> >
> > if plain old words like these cannot get results for example
> > from http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
> >
> > Finance - - - - - -
> >
> > Yield 1,21% 1,40% 1,59% 1,69% 1,84% 1,92%
> >
> > what is a good word for it?
> >
> > also, as you know, for example ''Sales''
> >
> > whereby the result
> >
> > ''99 870'' code is =0+SUBSTITUTE(RCHGetTableCell("
> > http://www.4-traders.com/ "&D2&"/financials/",1,"Sales";)," ","")
> >
> > ''106 916'' code is =0+SUBSTITUTE(RCHGetTableCell("
> > http://www.4-traders.com/ "&D2&"/financials/",2,"Sales";)," ","")
> >
> > is it possible to extract the word ''SALES''
> >
> > with
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"Sales";),"
> > ","")? i tried it but it gives an error
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",-1,"Sales";),"
> > ","") as well
> >
>
actually, what I need to extract is only the
EPS ( $) and Dividend per Share ( $)
as it may give varies result depending to what symbols I input
for example
in
http://www.4-
gives the result of
EPS ( $)
Dividend per Share ( $)
whereas
http://www.4-
gives the result of
EPS ( CNY)
Dividend per Share ( CNY)
that is why i wanted to use codes to extract that
for dividend per share, i used
=RCHGetTableCell(
and it worked fine
but for
=RCHGetTableCell(
it gives me an ''ERROR&#
is there any words i should use?
thanks!
--- In smf_addin@yahoogrou
>
> That's what there are multiple search strings, so that you can position
> yourself better. For example:
>
> =RCHGetTableCell(
> - Leverage"
> =RCHGetTableCell(
> Statement Data","
>
> I don't know why you would want to extract the word "Sales"
>
> =RCHGetTableCell(
>
> On Thu, May 23, 2013 at 9:12 AM, weekeewawa <weekeewawa@
>
> >
> > =0+SUBSTITUTE(
> > is working
> >
> > but the problem lies with the column ''Finance&#
> >
> > if plain old words like these cannot get results for example
> > from http://www.4-
> >
> > Finance - - - - - -
> >
> > Yield 1,21% 1,40% 1,59% 1,69% 1,84% 1,92%
> >
> > what is a good word for it?
> >
> > also, as you know, for example ''Sales&#
> >
> > whereby the result
> >
> > ''99 870'' code is =0+SUBSTITUTE(
> > http://www.4-
> >
> > ''106 916'' code is =0+SUBSTITUTE(
> > http://www.4-
> >
> > is it possible to extract the word ''SALES&#
> >
> > with
> >
> > =0+SUBSTITUTE(
> > ","
> >
> > =0+SUBSTITUTE(
> > ","
> >
>
Thu May 23, 2013 9:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, if you look at the source code and search for "EPS", you would have
noticed that the first place it is mentioned in NOT in the table, but in
the META tag at the top of the document that describes the web page. In
this case, changing it to ">EPS" should be sufficient.
On Thu, May 23, 2013 at 9:09 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"EPS ")
>
> it gives me an ''ERROR'' message
>
> is there any words i should use?
>
noticed that the first place it is mentioned in NOT in the table, but in
the META tag at the top of the document that describes the web page. In
this case, changing it to ">EPS" should be sufficient.
On Thu, May 23, 2013 at 9:09 PM, weekeewawa <weekeewawa@yahoo.
>
> =RCHGetTableCell(
>
> it gives me an ''ERROR&#
>
> is there any words i should use?
>
Thu May 23, 2013 9:41 pm (PDT) . Posted by:
"sri yanto" sri.yanto
hallo randy i wanna ask help again
i am using RCHgettable to retreive ft.com ---> "outstanding share" section
it's return "#Value!", i am load to 400 ticker in one sheet, at one acces.
not all "#Value!" as the result, there was some tick load as should.
but not spread evenly.
are in add-in have limitation to load sum of data?
PS : but in other sheet e.g: AALI.JK it can work properly, but when AALI.JK was in group of 400 tickers (load at once) it won't work.
Thank You Very Much.
i am using RCHgettable to retreive ft.com ---> "outstanding share" section
it's return "#Value!
not all "#Value!
but not spread evenly.
are in add-in have limitation to load sum of data?
PS : but in other sheet e.g: AALI.JK it can work properly, but when AALI.JK was in group of 400 tickers (load at once) it won't work.
Thank You Very Much.
Thu May 23, 2013 9:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you're doing 400 different web pages, that's 400 Internet accesses.
I'll need to see the exact formula...but #VALUE! on an add-in formula
usually means a parameter error.
The add-in does have an internal limitation of accessing only 1000 web
pages in a "session". It's meant for ad hoc data retrieval, not to load a
database. You should be using a screening tool to get it down to a smaller
set of stocks than 400 (or more).
On Thu, May 23, 2013 at 9:41 PM, sri yanto <sri.yanto@yahoo.com > wrote:
> hallo randy i wanna ask help again
>
> i am using RCHgettable to retreive ft.com ---> "outstanding share" section
>
> it's return "#Value!", i am load to 400 ticker in one sheet, at one acces.
>
> not all "#Value!" as the result, there was some tick load as should.
> but not spread evenly.
>
> are in add-in have limitation to load sum of data?
>
> PS : but in other sheet e.g: AALI.JK it can work properly, but when
> AALI.JK was in group of 400 tickers (load at once) it won't work.
>
> Thank You Very Much.
>
I'll need to see the exact formula...but #VALUE! on an add-in formula
usually means a parameter error.
The add-in does have an internal limitation of accessing only 1000 web
pages in a "session"
database. You should be using a screening tool to get it down to a smaller
set of stocks than 400 (or more).
On Thu, May 23, 2013 at 9:41 PM, sri yanto <sri.yanto@yahoo.
> hallo randy i wanna ask help again
>
> i am using RCHgettable to retreive ft.com ---> "outstanding share" section
>
> it's return "#Value!
>
> not all "#Value!
> but not spread evenly.
>
> are in add-in have limitation to load sum of data?
>
> PS : but in other sheet e.g: AALI.JK it can work properly, but when
> AALI.JK was in group of 400 tickers (load at once) it won't work.
>
> Thank You Very Much.
>
Thu May 23, 2013 11:11 pm (PDT) . Posted by:
"sri yanto" sri.yanto
here my
formula randy :
=(IF(RIGHT(RCHGetTableCell("http://markets.ft.com/tearsheets/performance.asp?s= "&$D2,1,"Shares outstanding"),2)="bn",1000000000,1000000)*LEFT(RCHGetTableCell("http://markets.ft.com/tearsheets/performance.asp?s= "&$D2,1,"Shares outstanding"),LEN($D2)-2))
D2 refers to AALI.JK or else
hmm..no iam not acces 400 different web pages, i only retrive Ft.com
but in 400 tickers in once acces
thank you very much
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> If you're doing 400 different web pages, that's 400 Internet accesses.
>
> I'll need to see the exact formula...but #VALUE! on an add-in formula
> usually means a parameter error.
>
> The add-in does have an internal limitation of accessing only 1000 web
> pages in a "session". It's meant for ad hoc data retrieval, not to load a
> database. You should be using a screening tool to get it down to a smaller
> set of stocks than 400 (or more).
>
> On Thu, May 23, 2013 at 9:41 PM, sri yanto <sri.yanto@...> wrote:
>
> > hallo randy i wanna ask help again
> >
> > i am using RCHgettable to retreive ft.com ---> "outstanding share" section
> >
> > it's return "#Value!", i am load to 400 ticker in one sheet, at one acces.
> >
> > not all "#Value!" as the result, there was some tick load as should.
> > but not spread evenly.
> >
> > are in add-in have limitation to load sum of data?
> >
> > PS : but in other sheet e.g: AALI.JK it can work properly, but when
> > AALI.JK was in group of 400 tickers (load at once) it won't work.
> >
> > Thank You Very Much.
> >
>
formula randy :
=(IF(RIGHT(RCHGetTa
D2 refers to AALI.JK or else
hmm..no iam not acces 400 different web pages, i only retrive Ft.com
but in 400 tickers in once acces
thank you very much
--- In smf_addin@yahoogrou
>
> If you're doing 400 different web pages, that's 400 Internet accesses.
>
> I'll need to see the exact formula...but #VALUE! on an add-in formula
> usually means a parameter error.
>
> The add-in does have an internal limitation of accessing only 1000 web
> pages in a "session"
> database. You should be using a screening tool to get it down to a smaller
> set of stocks than 400 (or more).
>
> On Thu, May 23, 2013 at 9:41 PM, sri yanto <sri.yanto@
>
> > hallo randy i wanna ask help again
> >
> > i am using RCHgettable to retreive ft.com ---> "outstanding share" section
> >
> > it's return "#Value!
> >
> > not all "#Value!
> > but not spread evenly.
> >
> > are in add-in have limitation to load sum of data?
> >
> > PS : but in other sheet e.g: AALI.JK it can work properly, but when
> > AALI.JK was in group of 400 tickers (load at once) it won't work.
> >
> > Thank You Very Much.
> >
>
Thu May 23, 2013 11:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Why would you do LEN($D2)-2? The #VALUE! error is coming from your formula,
not the add-in function.
But if you do that function on 400 different ticker symbols, you are
accessing the Internet 400 times. Once for each specific URL that is used
in an add-in formula.
On Thu, May 23, 2013 at 11:11 PM, sri yanto <sri.yanto@yahoo.com > wrote:
> here my
> formula randy :
>
> =(IF(RIGHT(RCHGetTableCell("
> http://markets.ft.com/tearsheets/performance.asp?s= "&$D2,1,"Shares
> outstanding"),2)="bn",1000000000,1000000)*LEFT(RCHGetTableCell("
> http://markets.ft.com/tearsheets/performance.asp?s= "&$D2,1,"Shares
> outstanding"),LEN($D2)-2))
>
> D2 refers to AALI.JK or else
>
> hmm..no iam not acces 400 different web pages, i only retrive Ft.com
> but in 400 tickers in once acces
>
not the add-in function.
But if you do that function on 400 different ticker symbols, you are
accessing the Internet 400 times. Once for each specific URL that is used
in an add-in formula.
On Thu, May 23, 2013 at 11:11 PM, sri yanto <sri.yanto@yahoo.
> here my
> formula randy :
>
> =(IF(RIGHT(RCHGetTa
> http://markets.
> outstanding"
> http://markets.
> outstanding"
>
> D2 refers to AALI.JK or else
>
> hmm..no iam not acces 400 different web pages, i only retrive Ft.com
> but in 400 tickers in once acces
>
Fri May 24, 2013 12:21 am (PDT) . Posted by:
"sri yanto" sri.yanto
i take LEN just for capture value of "ots share" that not contain numeric (text type), so i have to convert to numeric, for next formula i used.
yes maybe it's from my formula..but the questian is why not all get result but other tick can have result..?
Thank you very much
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Why would you do LEN($D2)-2? The #VALUE! error is coming from your formula,
> not the add-in function.
>
> But if you do that function on 400 different ticker symbols, you are
> accessing the Internet 400 times. Once for each specific URL that is used
> in an add-in formula.
>
> On Thu, May 23, 2013 at 11:11 PM, sri yanto <sri.yanto@...> wrote:
>
> > here my
> > formula randy :
> >
> > =(IF(RIGHT(RCHGetTableCell("
> > http://markets.ft.com/tearsheets/performance.asp?s= "&$D2,1,"Shares
> > outstanding"),2)="bn",1000000000,1000000)*LEFT(RCHGetTableCell("
> > http://markets.ft.com/tearsheets/performance.asp?s= "&$D2,1,"Shares
> > outstanding"),LEN($D2)-2))
> >
> > D2 refers to AALI.JK or else
> >
> > hmm..no iam not acces 400 different web pages, i only retrive Ft.com
> > but in 400 tickers in once acces
> >
>
yes maybe it's from my formula..but the questian is why not all get result but other tick can have result..?
Thank you very much
--- In smf_addin@yahoogrou
>
> Why would you do LEN($D2)-2? The #VALUE! error is coming from your formula,
> not the add-in function.
>
> But if you do that function on 400 different ticker symbols, you are
> accessing the Internet 400 times. Once for each specific URL that is used
> in an add-in formula.
>
> On Thu, May 23, 2013 at 11:11 PM, sri yanto <sri.yanto@
>
> > here my
> > formula randy :
> >
> > =(IF(RIGHT(RCHGetTa
> > http://markets.
> > outstanding"
> > http://markets.
> > outstanding"
> >
> > D2 refers to AALI.JK or else
> >
> > hmm..no iam not acces 400 different web pages, i only retrive Ft.com
> > but in 400 tickers in once acces
> >
>
Fri May 24, 2013 12:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It would just be a coincidence that the length of the ticker was the length
of the extracted field.
On Fri, May 24, 2013 at 12:21 AM, sri yanto <sri.yanto@yahoo.com > wrote:
> i take LEN just for capture value of "ots share" that not contain numeric
> (text type), so i have to convert to numeric, for next formula i used.
>
> yes maybe it's from my formula..but the questian is why not all get result
> but other tick can have result..?
>
of the extracted field.
On Fri, May 24, 2013 at 12:21 AM, sri yanto <sri.yanto@yahoo.
> i take LEN just for capture value of "ots share" that not contain numeric
> (text type), so i have to convert to numeric, for next formula i used.
>
> yes maybe it's from my formula..but the questian is why not all get result
> but other tick can have result..?
>
Fri May 24, 2013 12:32 am (PDT) . Posted by:
"sri yanto" sri.yanto
hmm okey randy
..thank you very much
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It would just be a coincidence that the length of the ticker was the length
> of the extracted field.
>
> On Fri, May 24, 2013 at 12:21 AM, sri yanto <sri.yanto@...> wrote:
>
> > i take LEN just for capture value of "ots share" that not contain numeric
> > (text type), so i have to convert to numeric, for next formula i used.
> >
> > yes maybe it's from my formula..but the questian is why not all get result
> > but other tick can have result..?
> >
>
..thank you very much
--- In smf_addin@yahoogrou
>
> It would just be a coincidence that the length of the ticker was the length
> of the extracted field.
>
> On Fri, May 24, 2013 at 12:21 AM, sri yanto <sri.yanto@
>
> > i take LEN just for capture value of "ots share" that not contain numeric
> > (text type), so i have to convert to numeric, for next formula i used.
> >
> > yes maybe it's from my formula..but the questian is why not all get result
> > but other tick can have result..?
> >
>
Fri May 24, 2013 2:41 am (PDT) . Posted by:
"V. Shankar" tarakayan
I am talking about simple direct downloads (excel version) of their various report from their website....there are now several reports and are specific. Previously it used to be one report with various details (quarterly, yearly, previous quarter, etc..).....
________________________________
From: bobc94595 <conlonrc@comcast.net >
To: smf_addin@yahoogroups.com
Sent: Tuesday, May 21, 2013 8:51 AM
Subject: [smf_addin] Re: getting Zacks data
What will you do to your templates in order to get Zacks info? I can't get Zacks.com on Firefox, IE, and Chrome, and can't get any Excel download with a Zacks code. The spreadsheets work with all other RCHGetElementNumbers.
--- In smf_addin@yahoogroups.com , "V. Shankar" <tarakayan@...> wrote:
>
> ZACKS in their website (think comes under media room) have made changes in their reports. They now have so many with several options. All my templates that work with downloads have to be redone.
>
>
> Sent from Yahoo! Mail on my iPad
>
____________
From: bobc94595 <conlonrc@comcast.
To: smf_addin@yahoogrou
Sent: Tuesday, May 21, 2013 8:51 AM
Subject: [smf_addin] Re: getting Zacks data
What will you do to your templates in order to get Zacks info? I can't get Zacks.com on Firefox, IE, and Chrome, and can't get any Excel download with a Zacks code. The spreadsheets work with all other RCHGetElementNumber
--- In smf_addin@yahoogrou
>
> ZACKS in their website (think comes under media room) have made changes in their reports. They now have so many with several options. All my templates that work with downloads have to be redone.
>
>
> Sent from Yahoo! Mail on my iPad
>
Tidak ada komentar:
Posting Komentar