15 New Messages
Digest #2633
Messages
Mon May 27, 2013 2:19 am (PDT) . Posted by:
"szazdrew" szazdrew
That's great! Exactly what I need. Thank You, Randy. It saves me a lot of hours.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It appears the source page for the split info is:
>
> http://performance.morningstar.com/PerformanceHtml/stock/split-history.action?t=F
--- In smf_addin@yahoogrou
>
> It appears the source page for the split info is:
>
> http://performance.
Mon May 27, 2013 5:11 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
works great!
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> wrote:
>
> >
> > =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"EPS ")
> >
> > it gives me an ''ERROR'' message
> >
> > is there any words i should use?
> >
>
works great!
thanks!
--- In smf_addin@yahoogrou
>
> Well, if you look at the source code and search for "EPS"
> 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@
>
> >
> > =RCHGetTableCell(
> >
> > it gives me an ''ERROR&#
> >
> > is there any words i should use?
> >
>
Mon May 27, 2013 5:41 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
works great!
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> wrote:
>
> >
> > =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"EPS ")
> >
> > it gives me an ''ERROR'' message
> >
> > is there any words i should use?
> >
>
works great!
thanks!
--- In smf_addin@yahoogrou
>
> Well, if you look at the source code and search for "EPS"
> 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@
>
> >
> > =RCHGetTableCell(
> >
> > it gives me an ''ERROR&#
> >
> > is there any words i should use?
> >
>
Mon May 27, 2013 6:11 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
works great!
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> wrote:
>
> >
> > =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"EPS ")
> >
> > it gives me an ''ERROR'' message
> >
> > is there any words i should use?
> >
>
works great!
thanks!
--- In smf_addin@yahoogrou
>
> Well, if you look at the source code and search for "EPS"
> 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@
>
> >
> > =RCHGetTableCell(
> >
> > it gives me an ''ERROR&#
> >
> > is there any words i should use?
> >
>
Mon May 27, 2013 3:46 pm (PDT) . Posted by:
"David Nicholson" djsnicholson
Hi Randy,
First of all, thank you for your insightful comments and patience in
providing such a valuable add-in to the financial arena and for answering
the wide array of questions ... some good some bad.
Unfortunately, I seem to be having the same Zacks data error problems as
Andy. Even though I have downloaded all of the file updates, the 2 data
errors as shown below persist.
=RCHGetElementNumber(Ticker, 848) Zacks Rank
and
=RCHGetElementNumber(Ticker, 13873) Zacks Recommendation
Everything seems to work except these two data retrievals. Is there a trick
to get this to work properly? Yes, I am a registered Zacks Premium member
and have logged in to my account in another window.
Thanks again.
Sincerely,
David N.
----SMF-TEMPLATE-ZACKS-
DATA-----------------------------------------------------
*06/2013* *09/2013* *12/2012* *12/2013* *ibm* $3.77 $3.85
$16.46 $18.00 *Low Estimate* $3.80 $3.98 $16.77 $18.68 *High Estimate*
$3.79 $3.94 $16.67 $18.36 *Average Estimate* $3.51 $3.62 $15.25 $16.67 *Year
Ago EPS* 7.9% 8.8% 9.3% 10.2% *EPS Growth* 6 6 8 15 *# of Estimates*
Error *Zacks Rank* Error *Zacks Recommendation* $218.00 *Target
Price Consensus* COMPUTER-INTEGRATED SYSTEMS *Industry Group*
101 *Rank of Industry* 5 *Rank Within Industry*
$229,280,000 *Market
Capitalization* 1.34 *PEG Ratio* $16.67 *Current Year Estimate
* $15.52 *EPS Last Year* $15.52 *Earning per Share (TTM)*
$104,507 *Sales* $16,570 *Net Income* 13.26 *Price/Earnings*
11.93 *Price/Book* 10.42 *Price/Cash Flow* 2.22 *
Price/Sales* *Average Broker Recommendations* 2.2 *Current*
2.2 *Last Week* 20 *# of Recommendations* $218.00 *Average
Target Price* 101 *Rank of Industry* 5 *Rank Within Industry*
----------------------------------------------------------
On Wed, Mar 13, 2013 at 9:34 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Thanks. I've fixed the element definition, from:
>
> Zacks;Zacks Recommendation;=smfStrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/~~~~~/detailed-estimates ","p",-1,"Zacks
> Rank:"),"-"," ")
>
> ....to:
>
> Zacks;Zacks Recommendation;=smfStrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/~~~~~/detailed-estimates ","p",-1,"Zacks
> Rank:"),"-","<")
>
> (Just changing that last string from " " to "<", to mark the end of the
> recommendation. When I did my testing, I must have had all single-word
> recommendations.
>
> On Wed, Mar 13, 2013 at 5:51 PM, andyha8 <andyha8@gmail.com > wrote:
>
>> Hey Randy, hope you're having a good day.
>>
>> When I punch in GMCR into the SMF-Template-Zacks-Data.xls, I just get
>> "strong", like not "strong buy" or "strong sell", just the one word
>> "strong".
>>
>> I guess I can figure out if it's a buy or sell from other info as in if
>> it's a rank 1 then it must be a buy but just thought I would bring it to
>> your attention.
>>
>
>
>
First of all, thank you for your insightful comments and patience in
providing such a valuable add-in to the financial arena and for answering
the wide array of questions ... some good some bad.
Unfortunately, I seem to be having the same Zacks data error problems as
Andy. Even though I have downloaded all of the file updates, the 2 data
errors as shown below persist.
=RCHGetElementNumbe
and
=RCHGetElementNumbe
Everything seems to work except these two data retrievals. Is there a trick
to get this to work properly? Yes, I am a registered Zacks Premium member
and have logged in to my account in another window.
Thanks again.
Sincerely,
David N.
----SMF-TEMPLATE-
DATA--------
*06/2013* *09/2013* *12/2012* *12/2013* *ibm* $3.77 $3.85
$16.46 $18.00 *Low Estimate* $3.80 $3.98 $16.77 $18.68 *High Estimate*
$3.79 $3.94 $16.67 $18.36 *Average Estimate* $3.51 $3.62 $15.25 $16.67 *Year
Ago EPS* 7.9% 8.8% 9.3% 10.2% *EPS Growth* 6 6 8 15 *# of Estimates*
Error *Zacks Rank* Error *Zacks Recommendation* $218.00 *Target
Price Consensus* COMPUTER-INTEGRATED SYSTEMS *Industry Group*
101 *Rank of Industry* 5 *Rank Within Industry*
$229,280,000 *Market
Capitalization* 1.34 *PEG Ratio* $16.67 *Current Year Estimate
* $15.52 *EPS Last Year* $15.52 *Earning per Share (TTM)*
$104,507 *Sales* $16,570 *Net Income* 13.26 *Price/Earnings*
11.93 *Price/Book* 10.42 *Price/Cash Flow* 2.22 *
Price/Sales* *Average Broker Recommendations* 2.2 *Current*
2.2 *Last Week* 20 *# of Recommendations* $218.00 *Average
Target Price* 101 *Rank of Industry* 5 *Rank Within Industry*
------------
On Wed, Mar 13, 2013 at 9:34 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Thanks. I've fixed the element definition, from:
>
> Zacks;Zacks Recommendation;
> http://www.zacks.
> Rank:")
>
> ....to:
>
> Zacks;Zacks Recommendation;
> http://www.zacks.
> Rank:")
>
> (Just changing that last string from " " to "<"
> recommendation. When I did my testing, I must have had all single-word
> recommendations.
>
> On Wed, Mar 13, 2013 at 5:51 PM, andyha8 <andyha8@gmail.
>
>> Hey Randy, hope you're having a good day.
>>
>> When I punch in GMCR into the SMF-Template-
>> "strong"
>> "strong"
>>
>> I guess I can figure out if it's a buy or sell from other info as in if
>> it's a rank 1 then it must be a buy but just thought I would bring it to
>> your attention.
>>
>
>
>
Mon May 27, 2013 6:02 pm (PDT) . Posted by:
"David Nicholson" djsnicholson
Randy,
Wow! I learned something new again!
Both the excel statements in your email and the excel statements in my
email work correctly in Excel 2010 but they all produce errors and do not
work in Excel 2003. That issue is a major revelation to me, and I am sure
that many other users were unaware of that limitation. Many data retrieval
calls probably exceed the limit to which you referred.
Thanks again for all that you do so tirelessly and your quick solution to
my dilemma.
David N.
On Mon, May 27, 2013 at 7:59 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> I just tried the template with both MMM and IBM, and both worked for me.
> Both of the element numbers you mention basically do:
>
> =smfStrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/IBM/detailed-estimates ",
> "p",-1,"Zacks Rank:"),": ","-")
>
> =smfStrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/IBM/detailed-estimates ",
> "p",-1,"Zacks Rank:"),"-","<")
>
> Do those work for you?
>
> Are you using an older version of EXCEL? The length of the
> smfGetTagContent() string from which the data is extracted may exceed the
> limits of earlier versions of EXCEL, when used the way the element
> definition is defined.
>
> On Mon, May 27, 2013 at 3:45 PM, David Nicholson <djsn@concentric.net >wrote:
>
>> Hi Randy,
>> First of all, thank you for your insightful comments and patience in
>> providing such a valuable add-in to the financial arena and for answering
>> the wide array of questions ... some good some bad.
>>
>> Unfortunately, I seem to be having the same Zacks data error problems as
>> Andy. Even though I have downloaded all of the file updates, the 2 data
>> errors as shown below persist.
>>
>> =RCHGetElementNumber(Ticker, 848) Zacks Rank
>>
>> and
>>
>> =RCHGetElementNumber(Ticker, 13873) Zacks Recommendation
>>
>> Everything seems to work except these two data retrievals. Is there a
>> trick to get this to work properly? Yes, I am a registered Zacks Premium
>> member and have logged in to my account in another window.
>>
>> Thanks again.
>>
>> Sincerely,
>> David N.
>>
>> ----SMF-TEMPLATE-ZACKS-
>> DATA-----------------------------------------------------
>> *06/2013* *09/2013* *12/2012* *12/2013* *ibm* $3.77 $3.85
>> $16.46 $18.00 *Low Estimate* $3.80 $3.98 $16.77 $18.68 *High Estimate*
>> $3.79 $3.94 $16.67 $18.36 *Average Estimate* $3.51 $3.62 $15.25 $16.67 *Year
>> Ago EPS* 7.9% 8.8% 9.3% 10.2% *EPS Growth* 6 6 8 15 *# of Estimates*
>> Error *Zacks Rank* Error *Zacks Recommendation* $218.00
>> *Target Price Consensus* COMPUTER-INTEGRATED SYSTEMS *Industry
>> Group* 101 *Rank of Industry* 5 *Rank Within Industry*
>> $229,280,000 *Market Capitalization* 1.34 *PEG Ratio*
>> $16.67 *Current Year Estimate* $15.52 *EPS Last Year*
>> $15.52 *Earning per Share (TTM)* $104,507 *Sales* $16,570 *Net
>> Income* 13.26 *Price/Earnings* 11.93 *Price/Book*
>> 10.42 *Price/Cash Flow* 2.22 *Price/Sales* *Average Broker
>> Recommendations* 2.2 *Current* 2.2 *Last Week* 20 *#
>> of Recommendations* $218.00 *Average Target Price* 101 *Rank
>> of Industry* 5 *Rank Within Industry*
>>
>> ----------------------------------------------------------
>>
>>
>>
>
Wow! I learned something new again!
Both the excel statements in your email and the excel statements in my
email work correctly in Excel 2010 but they all produce errors and do not
work in Excel 2003. That issue is a major revelation to me, and I am sure
that many other users were unaware of that limitation. Many data retrieval
calls probably exceed the limit to which you referred.
Thanks again for all that you do so tirelessly and your quick solution to
my dilemma.
David N.
On Mon, May 27, 2013 at 7:59 PM, Randy Harmelink <rharmelink@gmail.
> I just tried the template with both MMM and IBM, and both worked for me.
> Both of the element numbers you mention basically do:
>
> =smfStrExtr(
> http://www.zacks.
> "p"
>
> =smfStrExtr(
> http://www.zacks.
> "p"
>
> Do those work for you?
>
> Are you using an older version of EXCEL? The length of the
> smfGetTagContent(
> limits of earlier versions of EXCEL, when used the way the element
> definition is defined.
>
> On Mon, May 27, 2013 at 3:45 PM, David Nicholson <djsn@concentric.
>
>> Hi Randy,
>> First of all, thank you for your insightful comments and patience in
>> providing such a valuable add-in to the financial arena and for answering
>> the wide array of questions ... some good some bad.
>>
>> Unfortunately, I seem to be having the same Zacks data error problems as
>> Andy. Even though I have downloaded all of the file updates, the 2 data
>> errors as shown below persist.
>>
>> =RCHGetElementNumbe
>>
>> and
>>
>> =RCHGetElementNumbe
>>
>> Everything seems to work except these two data retrievals. Is there a
>> trick to get this to work properly? Yes, I am a registered Zacks Premium
>> member and have logged in to my account in another window.
>>
>> Thanks again.
>>
>> Sincerely,
>> David N.
>>
>> ----SMF-TEMPLATE-
>> DATA--------
>> *06/2013* *09/2013* *12/2012* *12/2013* *ibm* $3.77 $3.85
>> $16.46 $18.00 *Low Estimate* $3.80 $3.98 $16.77 $18.68 *High Estimate*
>> $3.79 $3.94 $16.67 $18.36 *Average Estimate* $3.51 $3.62 $15.25 $16.67 *Year
>> Ago EPS* 7.9% 8.8% 9.3% 10.2% *EPS Growth* 6 6 8 15 *# of Estimates*
>> Error *Zacks Rank* Error *Zacks Recommendation* $218.00
>> *Target Price Consensus* COMPUTER-INTEGRATED SYSTEMS *Industry
>> Group* 101 *Rank of Industry* 5 *Rank Within Industry*
>> $229,280,000 *Market Capitalization* 1.34 *PEG Ratio*
>> $16.67 *Current Year Estimate* $15.52 *EPS Last Year*
>> $15.52 *Earning per Share (TTM)* $104,507 *Sales* $16,570 *Net
>> Income* 13.26 *Price/Earnings* 11.93 *Price/Book*
>> 10.42 *Price/Cash Flow* 2.22 *Price/Sales* *Average Broker
>> Recommendations* 2.2 *Current* 2.2 *Last Week* 20 *#
>> of Recommendations* $218.00 *Average Target Price* 101 *Rank
>> of Industry* 5 *Rank Within Industry*
>>
>> ------------
>>
>>
>>
>
Mon May 27, 2013 6:00 pm (PDT) . Posted by:
"wasaiclub" wasaiclub
For a Value perpective, I would like to try to screen for Net Net Working Capital where
NNWC = Cash & Equivalents + Accounts Receivables + Inventory - Total Liabilities
Are there smf element codes for a symbol's --
Cash & Equivalents
Current Assets (I'm not sure if this is the same as Cash & Equivalents)
Accounts Receivables
Inventory
Total Liabilities
Thanks a lot for your help.
Seth
NNWC = Cash & Equivalents + Accounts Receivables + Inventory - Total Liabilities
Are there smf element codes for a symbol's --
Cash & Equivalents
Current Assets (I'm not sure if this is the same as Cash & Equivalents)
Accounts Receivables
Inventory
Total Liabilities
Thanks a lot for your help.
Seth
Mon May 27, 2013 6:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in really isn't a screening tool. I don't want people creating
databases by downloading data on a large number of stocks from the free
services. It just gives them an incentive to prevent things like the add-in
from being able to access the data. If you want a database screening tool,
I'd suggest looking at either AAII's Stock Investor Pro or Portfolio123.com.
Having said that, you can grab the items you need. However, you'll need to
know your data source. For example, Yahoo includes "Restricted Cash" in
their definition of "Cash & Equivalents".
Ideally, what you should do is use an online screening tool to get you down
to a workable set of stocks, and then use the add-in to grab the details on
that small subset of stocks.
On Mon, May 27, 2013 at 5:46 PM, wasaiclub <wasaiclub@yahoo.com > wrote:
> For a Value perpective, I would like to try to screen for Net Net Working
> Capital where
>
> NNWC = Cash & Equivalents + Accounts Receivables + Inventory - Total
> Liabilities
>
> Are there smf element codes for a symbol's --
>
> Cash & Equivalents
> Current Assets (I'm not sure if this is the same as Cash & Equivalents)
> Accounts Receivables
> Inventory
> Total Liabilities
>
databases by downloading data on a large number of stocks from the free
services. It just gives them an incentive to prevent things like the add-in
from being able to access the data. If you want a database screening tool,
I'd suggest looking at either AAII's Stock Investor Pro or Portfolio123.
Having said that, you can grab the items you need. However, you'll need to
know your data source. For example, Yahoo includes "Restricted Cash" in
their definition of "Cash & Equivalents"
Ideally, what you should do is use an online screening tool to get you down
to a workable set of stocks, and then use the add-in to grab the details on
that small subset of stocks.
On Mon, May 27, 2013 at 5:46 PM, wasaiclub <wasaiclub@yahoo.
> For a Value perpective, I would like to try to screen for Net Net Working
> Capital where
>
> NNWC = Cash & Equivalents + Accounts Receivables + Inventory - Total
> Liabilities
>
> Are there smf element codes for a symbol's --
>
> Cash & Equivalents
> Current Assets (I'm not sure if this is the same as Cash & Equivalents)
> Accounts Receivables
> Inventory
> Total Liabilities
>
Mon May 27, 2013 8:10 pm (PDT) . Posted by:
"sri yanto" sri.yanto
hai randy - sory bothering you again :D
i have founnd, that i compared have Reuters and FT.com with WSJ, WSJ is the best data provider, over accuracy and data update.
but i have trouble here.
i am using rchgettable here :
=RCHGetTableCell("http://quotes.wsj.com/ID/XIDX/UNTR/financials/annual/income-statement ",1,"Sales/Revenue")
but the questian is, how to make it become refreshable link for other ticker.
i tried to make formula but return "error", here the formula :
=RCHGetTableCell("http://quotes.wsj.com/ID/XIDX/=A1/financials/annual/income-statement ",1,"Sales/Revenue")
"=A1" refers to ticker i want to put ( UNTR)
thank you very much :D
i have founnd, that i compared have Reuters and FT.com with WSJ, WSJ is the best data provider, over accuracy and data update.
but i have trouble here.
i am using rchgettable here :
=RCHGetTableCell(
but the questian is, how to make it become refreshable link for other ticker.
i tried to make formula but return "error"
=RCHGetTableCell(
"=A1" refers to ticker i want to put ( UNTR)
thank you very much :D
Mon May 27, 2013 8:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just normal EXCEL concatenation -- this is just one string:
"http://quotes.wsj.com/ID/XIDX/=A1/financials/annual/income-statement "
You need to concatenate three strings:
"http://quotes.wsj.com/ID/XIDX/ "
A1
"/financials/annual/income-statement"
So:
"http://quotes.wsj.com/ID/XIDX/ " & A1 &
"/financials/annual/income-statement"
On Mon, May 27, 2013 at 8:10 PM, sri yanto <sri.yanto@yahoo.com > wrote:
> hai randy - sory bothering you again :D
>
> i have founnd, that i compared have Reuters and FT.com with WSJ, WSJ is
> the best data provider, over accuracy and data update.
>
> but i have trouble here.
>
> i am using rchgettable here :
>
> =RCHGetTableCell("
> http://quotes.wsj.com/ID/XIDX/UNTR/financials/annual/income-statement
> ",1,"Sales/Revenue")
>
> but the questian is, how to make it become refreshable link for other
> ticker.
> i tried to make formula but return "error", here the formula :
>
> =RCHGetTableCell("
> http://quotes.wsj.com/ID/XIDX/=A1/financials/annual/income-statement
> ",1,"Sales/Revenue")
>
> "=A1" refers to ticker i want to put ( UNTR)
>
"http://quotes.
You need to concatenate three strings:
"http://quotes.
A1
"/financials/
So:
"http://quotes.
"/financials/
On Mon, May 27, 2013 at 8:10 PM, sri yanto <sri.yanto@yahoo.
> hai randy - sory bothering you again :D
>
> i have founnd, that i compared have Reuters and FT.com with WSJ, WSJ is
> the best data provider, over accuracy and data update.
>
> but i have trouble here.
>
> i am using rchgettable here :
>
> =RCHGetTableCell(
> http://quotes.
> ",1,"
>
> but the questian is, how to make it become refreshable link for other
> ticker.
> i tried to make formula but return "error"
>
> =RCHGetTableCell(
> http://quotes.
> ",1,"
>
> "=A1" refers to ticker i want to put ( UNTR)
>
Mon May 27, 2013 8:48 pm (PDT) . Posted by:
"sri yanto" sri.yanto
okey, done randy...thank you so much
it's work ...thank you very much
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just normal EXCEL concatenation -- this is just one string:
>
> "http://quotes.wsj.com/ID/XIDX/=A1/financials/annual/income-statement "
>
> You need to concatenate three strings:
>
> "http://quotes.wsj.com/ID/XIDX/ "
> A1
> "/financials/annual/income-statement"
>
> So:
>
> "http://quotes.wsj.com/ID/XIDX/ " & A1 &
> "/financials/annual/income-statement"
>
> On Mon, May 27, 2013 at 8:10 PM, sri yanto <sri.yanto@...> wrote:
>
> > hai randy - sory bothering you again :D
> >
> > i have founnd, that i compared have Reuters and FT.com with WSJ, WSJ is
> > the best data provider, over accuracy and data update.
> >
> > but i have trouble here.
> >
> > i am using rchgettable here :
> >
> > =RCHGetTableCell("
> > http://quotes.wsj.com/ID/XIDX/UNTR/financials/annual/income-statement
> > ",1,"Sales/Revenue")
> >
> > but the questian is, how to make it become refreshable link for other
> > ticker.
> > i tried to make formula but return "error", here the formula :
> >
> > =RCHGetTableCell("
> > http://quotes.wsj.com/ID/XIDX/=A1/financials/annual/income-statement
> > ",1,"Sales/Revenue")
> >
> > "=A1" refers to ticker i want to put ( UNTR)
> >
>
it's work ...thank you very much
--- In smf_addin@yahoogrou
>
> Just normal EXCEL concatenation -- this is just one string:
>
> "http://quotes.
>
> You need to concatenate three strings:
>
> "http://quotes.
> A1
> "/financials/
>
> So:
>
> "http://quotes.
> "/financials/
>
> On Mon, May 27, 2013 at 8:10 PM, sri yanto <sri.yanto@
>
> > hai randy - sory bothering you again :D
> >
> > i have founnd, that i compared have Reuters and FT.com with WSJ, WSJ is
> > the best data provider, over accuracy and data update.
> >
> > but i have trouble here.
> >
> > i am using rchgettable here :
> >
> > =RCHGetTableCell(
> > http://quotes.
> > ",1,"
> >
> > but the questian is, how to make it become refreshable link for other
> > ticker.
> > i tried to make formula but return "error"
> >
> > =RCHGetTableCell(
> > http://quotes.
> > ",1,"
> >
> > "=A1" refers to ticker i want to put ( UNTR)
> >
>
Tue May 28, 2013 2:42 am (PDT) . Posted by:
"Ashwin Kumar" ashwin_rn186
Hi All,
I ve installed latest version of add-in posted here. I tested it and its working fine too. Now I need to know how to bring out the company's financial details while using the add-in, since the link that you provided (moneycentral.msn.com) was not based on Indian companies. For example, if i want to check for Indian origin companies like shriram transport finance, MCX, Ashok Leyland etc. how can I perform the add-in to know the ticker symbol of it. Kindly help me in this regard ASAP as this is the last step of my work on add-in. Thanks in advance.
Regards,
Ashwin
I ve installed latest version of add-in posted here. I tested it and its working fine too. Now I need to know how to bring out the company'
Regards,
Ashwin
Tue May 28, 2013 2:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't do anything with non-US companies, so I can't be of help in
pointing out resources.
If you have a site you use, I'd suggest searching the message archives of
the group to see if it has been discussed in the past.
On Mon, May 27, 2013 at 11:51 PM, Ashwin Kumar <ashwin_rn186@yahoo.com >wrote:
>
> I ve installed latest version of add-in posted here. I tested it and its
> working fine too. Now I need to know how to bring out the company's
> financial details while using the add-in, since the link that you provided (
> moneycentral.msn.com) was not based on Indian companies. For example, if
> i want to check for Indian origin companies like shriram transport finance,
> MCX, Ashok Leyland etc. how can I perform the add-in to know the ticker
> symbol of it. Kindly help me in this regard ASAP as this is the last step
> of my work on add-in. Thanks in advance.
>
pointing out resources.
If you have a site you use, I'd suggest searching the message archives of
the group to see if it has been discussed in the past.
On Mon, May 27, 2013 at 11:51 PM, Ashwin Kumar <ashwin_rn186@
>
> I ve installed latest version of add-in posted here. I tested it and its
> working fine too. Now I need to know how to bring out the company'
> financial details while using the add-in, since the link that you provided (
> moneycentral.
> i want to check for Indian origin companies like shriram transport finance,
> MCX, Ashok Leyland etc. how can I perform the add-in to know the ticker
> symbol of it. Kindly help me in this regard ASAP as this is the last step
> of my work on add-in. Thanks in advance.
>
Tue May 28, 2013 2:42 am (PDT) . Posted by:
"Ashwin Kumar R N" ashwin_rn186
Hi,
I installed the latest version of SMF add-in. I tested and it's working fine too. Now I need to start using it. When seeing the sample data given for company like Johnson & Johnson, IBM etc. the add-in works with the function =RCHGetElem
Regards,
Ashwin.
Tue May 28, 2013 2:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What did you try with RCHGetTableCell()? I can't be of any help without the
particulars of what you're trying to extract and from where.
And, as I mentioned, you can always search the message archives of the
group to see if the website you're interested in using has been discussed
before.
On Tue, May 28, 2013 at 2:40 AM, Ashwin Kumar R N <ashwin_rn186@yahoo.com >wrote:
>
>
> I installed the latest version of SMF add-in. I tested and it's working
> fine too. Now I need to start using it. When seeing the sample data given
> for company like Johnson & Johnson, IBM etc. the add-in works with the
> function =RCHGetElementNumber. But I need to view the details of Indian
> origin companies too like Ashok Leyland, Multi Commodity Exchange, Shriram
> Transport Finance etc. and other companies which is key for our financial
> analysis. When I tried with same function it doesnt work. My fellow
> colleague suggested to use the function =RCHgettablecell, so that I can get
> the data from any site, but still didnt work. What can I do ?? It's very
> UREGNT & this is my last step in add-in. Kindly help me in this regard
> ASAP. Thanks in advance.
>
>
particulars of what you're trying to extract and from where.
And, as I mentioned, you can always search the message archives of the
group to see if the website you're interested in using has been discussed
before.
On Tue, May 28, 2013 at 2:40 AM, Ashwin Kumar R N <ashwin_rn186@
>
>
> I installed the latest version of SMF add-in. I tested and it's working
> fine too. Now I need to start using it. When seeing the sample data given
> for company like Johnson & Johnson, IBM etc. the add-in works with the
> function =RCHGetElementNumbe
> origin companies too like Ashok Leyland, Multi Commodity Exchange, Shriram
> Transport Finance etc. and other companies which is key for our financial
> analysis. When I tried with same function it doesnt work. My fellow
> colleague suggested to use the function =RCHgettablecell, so that I can get
> the data from any site, but still didnt work. What can I do ?? It's very
> UREGNT & this is my last step in add-in. Kindly help me in this regard
> ASAP. Thanks in advance.
>
>
Tidak ada komentar:
Posting Komentar