10 New Messages
Digest #2563
1f
How to control addin's updating information at initial open or durin by "Kermit W. Prather" kermitpra
1g
Re: How to control addin's updating information at initial open or d by "Randy Harmelink" rharmelink
Messages
Thu Mar 28, 2013 7:25 am (PDT) . Posted by:
"Subu S" mail_to_subu
Dear Randy and others
Good day to you
Hope all's well here ...it's been some time since I visited this board [i'm sure my absence must have been a relief :-) ]
I have a request and 'am hoping that there *already* exists a solution so that I trouble Randy *very little *
What am I looking for :
--------------------------------
* As most of you know Benjamin Graham the guru of value investing advocated buying great value stocks cheap or say at a discount to value.
* He had a few screens to decide on "value" and then couple of formulate to decide cheap / not so cheap
* I wish to download this data [as advised by Graham] once in say 3 months or so & extract them to a worksheet ... NOT update every time the sp sheet opens, but one time download and save [and the rest of working I should be able to do on the WS ]
* I visited the files section of this group thinking that there should be a ready made XL file that already provided graham #s
* I could NOT find it
* I found this 10 year XL sheet http://bit.ly/11RKZzZ which is fantastic to say the least , but I am looking at a list with the ticker on the left extreme column and data on the rest of the columns ...something like this sheet http://bit.ly/YLqGS1 ,,, JUST the format like this .... BUT something to download the data, NOT update every time
Request :
--------------------------------
Could I request Randy and others to help me with getting the following data of listed stocks in a table . Ticker on left extreme column, rest on the columns to the right , one time download every three months
Better still, to avoid hitting servers often IF there is some data that is say within 1 month old, please mail / post the same and I'll use it
Specifics about "..What am I looking for.." /
and what did Benjamin Graham say
-------------------------------------------------
For each item I have listed what I am looking for followed byBenjamin Graham's distilled wisdom
1. What am I looking for = Market Cap
Ben Graham = "Adequate"; enterprise size, as insulation against the "vicissitudes" of the economy [ Subu's note I recall he said $ 100 mill those days, In my XL sheet I plan to inflate it to accommodate the money printing ]
2. What am I looking for = Current Ratio
2.1. Value of Total Current assets [for total enterprise]
2.2. Value of long term debt [for total enterprise]
Ben Graham = Strong financial condition, measured by current ratios that exceed two and net current assets that exceed long term debt;
3. Net profit for the last 10 years
Ben Graham = Earnings stability, measured by 10 consecutive years of positive earnings;
4. Dividends paid over the last 10 years
Ben Graham = A dividend record of uninterrupted payments for at least 20 years; [Subu's note ... yeah it should be 20 years, but I guess going back 20 is tough ...so I'm diluting it here ... bad ...but ok for the moment]
5. EPS today ; EPS 10 years ago
Ben Graham = Earnings-per-share growth of at least one-third over the last ten years;
6. PE Ratio
Ben Graham = Moderate price-to-earnings ratios, which typically should not exceed 15; and
7. Price to book ratio
Ben Graham = Moderate price-to-book ratios, which typically should not exceed 1½.
Many thanks in advance
Best regards
Subu
Good day to you
Hope all's well here ...it's been some time since I visited this board [i'm sure my absence must have been a relief :-) ]
I have a request and 'am hoping that there *already* exists a solution so that I trouble Randy *very little *
What am I looking for :
------------
* As most of you know Benjamin Graham the guru of value investing advocated buying great value stocks cheap or say at a discount to value.
* He had a few screens to decide on "value" and then couple of formulate to decide cheap / not so cheap
* I wish to download this data [as advised by Graham] once in say 3 months or so & extract them to a worksheet ... NOT update every time the sp sheet opens, but one time download and save [and the rest of working I should be able to do on the WS ]
* I visited the files section of this group thinking that there should be a ready made XL file that already provided graham #s
* I could NOT find it
* I found this 10 year XL sheet http://bit.ly/
Request :
------------
Could I request Randy and others to help me with getting the following data of listed stocks in a table . Ticker on left extreme column, rest on the columns to the right , one time download every three months
Better still, to avoid hitting servers often IF there is some data that is say within 1 month old, please mail / post the same and I'll use it
Specifics about "..What am I looking for.." /
and what did Benjamin Graham say
------------
For each item I have listed what I am looking for followed byBenjamin Graham's distilled wisdom
1. What am I looking for = Market Cap
Ben Graham = "Adequate"
2. What am I looking for = Current Ratio
2.1. Value of Total Current assets [for total enterprise]
2.2. Value of long term debt [for total enterprise]
Ben Graham = Strong financial condition, measured by current ratios that exceed two and net current assets that exceed long term debt;
3. Net profit for the last 10 years
Ben Graham = Earnings stability, measured by 10 consecutive years of positive earnings;
4. Dividends paid over the last 10 years
Ben Graham = A dividend record of uninterrupted payments for at least 20 years; [Subu's note ... yeah it should be 20 years, but I guess going back 20 is tough ...so I'm diluting it here ... bad ...but ok for the moment]
5. EPS today ; EPS 10 years ago
Ben Graham = Earnings-per-
6. PE Ratio
Ben Graham = Moderate price-to-earnings ratios, which typically should not exceed 15; and
7. Price to book ratio
Ben Graham = Moderate price-to-book ratios, which typically should not exceed 1½.
Many thanks in advance
Best regards
Subu
Thu Mar 28, 2013 7:40 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I am trying to capture just the numeric value in this case the 3 after the
rating number.
I have tried several iterations but keep getting 3Average as the returned
value.
Here is my last attempt
=RCHGetTableCell("http://dividata.com/stock/ "&A3,0,"rating_bar rating_bar")
Webpage:
http://dividata.com/stock/AGNC starting at line 186 in the HTML source
<h2 class="headline">(AGNC) DIVIDEND RATINGS:</h2>
<table id="ratings">
<tr>
<td class="descrip"><strong>Overall Rating:</strong></td>
<td><div class="rating_bar rating_bar_3">
<span class="rating_number">3</span>
<span class="rating_text";>Average</span>
</div></td>
</tr>
<tr>
Appreciate your help on this.
Kermit
rating number.
I have tried several iterations but keep getting 3Average as the returned
value.
Here is my last attempt
=RCHGetTableCell(
Webpage:
http://dividata.
<h2 class="
<table id="ratings&qu
<tr>
<td class="
<td><
<span class="
<span class="
</div>
</tr>
<tr>
Appreciate your help on this.
Kermit
Thu Mar 28, 2013 7:57 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Subu, neither of your links worked. Can you try again?
As for the information you are looking for I suggest you open the element
definition file of the addin and search for the elements
Such as Current assets elements 253 - 262, 3042 - 3046, 3662 - 3667, and
more
I'm pretty sure all the information has an element in the 14,000 plus
definitions.
Let us know if you need help in how to evaulaute the information. I,
personally, don't know Graham's method but might be willing to learn
something new to me.
Good luck,
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Subu S
Sent: Thursday, March 28, 2013 10:26 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Ben Graham screen
Dear Randy and others
Good day to you
Hope all's well here ...it's been some time since I visited this board [i'm
sure my absence must have been a relief :-) ]
I have a request and 'am hoping that there *already* exists a solution so
that I trouble Randy *very little *
What am I looking for :
--------------------------------
* As most of you know Benjamin Graham the guru of value investing advocated
buying great value stocks cheap or say at a discount to value.
* He had a few screens to decide on "value" and then couple of formulate to
decide cheap / not so cheap
* I wish to download this data [as advised by Graham] once in say 3 months
or so & extract them to a worksheet ... NOT update every time the sp sheet
opens, but one time download and save [and the rest of working I should be
able to do on the WS ]
* I visited the files section of this group thinking that there should be a
ready made XL file that already provided graham #s
* I could NOT find it
* I found this 10 year XL sheet http://bit.ly/11RKZzZ which is fantastic to
say the least , but I am looking at a list with the ticker on the left
extreme column and data on the rest of the columns ...something like this
sheet http://bit.ly/YLqGS1 ,,, JUST the format like this .... BUT something
to download the data, NOT update every time
Request :
--------------------------------
Could I request Randy and others to help me with getting the following data
of listed stocks in a table . Ticker on left extreme column, rest on the
columns to the right , one time download every three months
Better still, to avoid hitting servers often IF there is some data that is
say within 1 month old, please mail / post the same and I'll use it
Specifics about "..What am I looking for.." / and what did Benjamin Graham
say
-------------------------------------------------
For each item I have listed what I am looking for followed byBenjamin
Graham's distilled wisdom
1. What am I looking for = Market Cap
Ben Graham = "Adequate"; enterprise size, as insulation against the
"vicissitudes" of the economy [ Subu's note I recall he said $ 100 mill
those days, In my XL sheet I plan to inflate it to accommodate the money
printing ]
2. What am I looking for = Current Ratio
2.1. Value of Total Current assets [for total enterprise]
2.2. Value of long term debt [for total enterprise]
Ben Graham = Strong financial condition, measured by current ratios that
exceed two and net current assets that exceed long term debt;
3. Net profit for the last 10 years
Ben Graham = Earnings stability, measured by 10 consecutive years of
positive earnings;
4. Dividends paid over the last 10 years
Ben Graham = A dividend record of uninterrupted payments for at least 20
years; [Subu's note ... yeah it should be 20 years, but I guess going back
20 is tough ...so I'm diluting it here ... bad ...but ok for the moment]
5. EPS today ; EPS 10 years ago
Ben Graham = Earnings-per-share growth of at least one-third over the last
ten years;
6. PE Ratio
Ben Graham = Moderate price-to-earnings ratios, which typically should not
exceed 15; and
7. Price to book ratio
Ben Graham = Moderate price-to-book ratios, which typically should not
exceed 1½.
Many thanks in advance
Best regards
Subu
------------------------------------
Yahoo! Groups Links
As for the information you are looking for I suggest you open the element
definition file of the addin and search for the elements
Such as Current assets elements 253 - 262, 3042 - 3046, 3662 - 3667, and
more
I'm pretty sure all the information has an element in the 14,000 plus
definitions.
Let us know if you need help in how to evaulaute the information. I,
personally, don't know Graham's method but might be willing to learn
something new to me.
Good luck,
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of Subu S
Sent: Thursday, March 28, 2013 10:26 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Ben Graham screen
Dear Randy and others
Good day to you
Hope all's well here ...it's been some time since I visited this board [i'm
sure my absence must have been a relief :-) ]
I have a request and 'am hoping that there *already* exists a solution so
that I trouble Randy *very little *
What am I looking for :
------------
* As most of you know Benjamin Graham the guru of value investing advocated
buying great value stocks cheap or say at a discount to value.
* He had a few screens to decide on "value" and then couple of formulate to
decide cheap / not so cheap
* I wish to download this data [as advised by Graham] once in say 3 months
or so & extract them to a worksheet ... NOT update every time the sp sheet
opens, but one time download and save [and the rest of working I should be
able to do on the WS ]
* I visited the files section of this group thinking that there should be a
ready made XL file that already provided graham #s
* I could NOT find it
* I found this 10 year XL sheet http://bit.ly/
say the least , but I am looking at a list with the ticker on the left
extreme column and data on the rest of the columns ...something like this
sheet http://bit.ly/
to download the data, NOT update every time
Request :
------------
Could I request Randy and others to help me with getting the following data
of listed stocks in a table . Ticker on left extreme column, rest on the
columns to the right , one time download every three months
Better still, to avoid hitting servers often IF there is some data that is
say within 1 month old, please mail / post the same and I'll use it
Specifics about "..What am I looking for.." / and what did Benjamin Graham
say
------------
For each item I have listed what I am looking for followed byBenjamin
Graham's distilled wisdom
1. What am I looking for = Market Cap
Ben Graham = "Adequate"
"vicissitudes&
those days, In my XL sheet I plan to inflate it to accommodate the money
printing ]
2. What am I looking for = Current Ratio
2.1. Value of Total Current assets [for total enterprise]
2.2. Value of long term debt [for total enterprise]
Ben Graham = Strong financial condition, measured by current ratios that
exceed two and net current assets that exceed long term debt;
3. Net profit for the last 10 years
Ben Graham = Earnings stability, measured by 10 consecutive years of
positive earnings;
4. Dividends paid over the last 10 years
Ben Graham = A dividend record of uninterrupted payments for at least 20
years; [Subu's note ... yeah it should be 20 years, but I guess going back
20 is tough ...so I'm diluting it here ... bad ...but ok for the moment]
5. EPS today ; EPS 10 years ago
Ben Graham = Earnings-per-
ten years;
6. PE Ratio
Ben Graham = Moderate price-to-earnings ratios, which typically should not
exceed 15; and
7. Price to book ratio
Ben Graham = Moderate price-to-book ratios, which typically should not
exceed 1½.
Many thanks in advance
Best regards
Subu
------------
Yahoo! Groups Links
Thu Mar 28, 2013 9:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's because both items are in the same table cell. You need to get it
other than the table cell, or parse the content of the table cell. Try:
=0+smfGetTagContent("http://dividata.com/stock/ "&A3,"span",1,"rating_bar
rating_bar")
On Thu, Mar 28, 2013 at 7:40 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
> I am trying to capture just the numeric value in this case the 3 after
> the rating number.****
>
> I have tried several iterations but keep getting 3Average as the returned
> value.****
>
> Here is my last attempt ****
>
> =RCHGetTableCell("http://dividata.com/stock/ "&A3,0,"rating_bar
> rating_bar") ****
>
> Webpage: ****
>
> http://dividata.com/stock/AGNC starting at line 186 in the HTML source ***
> *
>
> <h2 class="headline">(AGNC) DIVIDEND RATINGS:</h2>****
>
> <table id="ratings">****
>
> <tr>****
>
> <td class="descrip"><strong>Overall Rating:</strong></td>****
>
> <td><div class="rating_bar rating_bar_3">****
>
> <span class="rating_number">*3*</span>****
>
> <span class="rating_text";>Average</span>****
>
> </div></td>****
>
> </tr>****
>
> <tr>****
>
> Appreciate your help on this.
>
other than the table cell, or parse the content of the table cell. Try:
=0+smfGetTagContent
rating_bar"
On Thu, Mar 28, 2013 at 7:40 AM, Kermit W. Prather
<kermitp@tampabay.
> I am trying to capture just the numeric value in this case the 3 after
> the rating number.****
>
> I have tried several iterations but keep getting 3Average as the returned
> value.****
>
> Here is my last attempt ****
>
> =RCHGetTableCell(
> rating_bar"
>
> Webpage: ****
>
> http://dividata.
> *
>
> <h2 class="
>
> <table id="ratings&qu
>
> <tr>**
>
> <td class="
>
> <td><
>
> <span class="
>
> <span class="
>
> </div>
>
> </tr>*
>
> <tr>**
>
> Appreciate your help on this.
>
Thu Mar 28, 2013 9:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I think you want to do something along the lines of an
smfUpdateDownloadTable workbook, since it grabs values instead of using
formulas that recalculate.
But the number of data items you're asking for would be a tough spreadsheet
to fill.
And I'm not sure what the purpose of the workbook would be. It sounds like
you need a screening tool, not something like the add-in.
By the way, the "f1.grp..." URLs for files are only temporary ones, so your
links don't work...
On Thu, Mar 28, 2013 at 7:25 AM, Subu S <mail_to_subu@yahoo.com > wrote:
> Dear Randy and others
>
>
> Good day to you
>
> Hope all's well here ...it's been some time since I visited this board
> [i'm sure my absence must have been a relief :-) ]
>
> I have a request and 'am hoping that there *already* exists a solution so
> that I trouble Randy *very little *
>
>
> What am I looking for :
> --------------------------------
> * As most of you know Benjamin Graham the guru of value investing
> advocated buying great value stocks cheap or say at a discount to value.
>
> * He had a few screens to decide on "value" and then couple of formulate
> to decide cheap / not so cheap
>
> * I wish to download this data [as advised by Graham] once in say 3 months
> or so & extract them to a worksheet ... NOT update every time the sp sheet
> opens, but one time download and save [and the rest of working I should be
> able to do on the WS ]
>
> * I visited the files section of this group thinking that there should be
> a ready made XL file that already provided graham #s
>
> * I could NOT find it
>
> * I found this 10 year XL sheet http://bit.ly/11RKZzZ which is fantastic
> to say the least , but I am looking at a list with the ticker on the left
> extreme column and data on the rest of the columns ...something like this
> sheet http://bit.ly/YLqGS1 ,,, JUST the format like this .... BUT
> something to download the data, NOT update every time
>
> Request :
> --------------------------------
> Could I request Randy and others to help me with getting the following
> data of listed stocks in a table . Ticker on left extreme column, rest on
> the columns to the right , one time download every three months
>
> Better still, to avoid hitting servers often IF there is some data that is
> say within 1 month old, please mail / post the same and I'll use it
>
>
> Specifics about "..What am I looking for.." /
> and what did Benjamin Graham say
> -------------------------------------------------
>
> For each item I have listed what I am looking for followed byBenjamin
> Graham's distilled wisdom
>
>
> 1. What am I looking for = Market Cap
>
> Ben Graham = "Adequate"; enterprise size, as insulation against the
> "vicissitudes" of the economy [ Subu's note I recall he said $ 100 mill
> those days, In my XL sheet I plan to inflate it to accommodate the money
> printing ]
>
>
> 2. What am I looking for = Current Ratio
> 2.1. Value of Total Current assets [for total enterprise]
> 2.2. Value of long term debt [for total enterprise]
>
> Ben Graham = Strong financial condition, measured by current ratios that
> exceed two and net current assets that exceed long term debt;
>
>
> 3. Net profit for the last 10 years
>
> Ben Graham = Earnings stability, measured by 10 consecutive years of
> positive earnings;
>
>
> 4. Dividends paid over the last 10 years
>
> Ben Graham = A dividend record of uninterrupted payments for at least 20
> years; [Subu's note ... yeah it should be 20 years, but I guess going back
> 20 is tough ...so I'm diluting it here ... bad ...but ok for the moment]
>
>
> 5. EPS today ; EPS 10 years ago
>
> Ben Graham = Earnings-per-share growth of at least one-third over the last
> ten years;
>
>
> 6. PE Ratio
>
> Ben Graham = Moderate price-to-earnings ratios, which typically should not
> exceed 15; and
>
>
> 7. Price to book ratio
>
> Ben Graham = Moderate price-to-book ratios, which typically should not
> exceed 1½.
>
smfUpdateDownloadTa
formulas that recalculate.
But the number of data items you're asking for would be a tough spreadsheet
to fill.
And I'm not sure what the purpose of the workbook would be. It sounds like
you need a screening tool, not something like the add-in.
By the way, the "f1.grp.
links don't work...
On Thu, Mar 28, 2013 at 7:25 AM, Subu S <mail_to_subu@
> Dear Randy and others
>
>
> Good day to you
>
> Hope all's well here ...it's been some time since I visited this board
> [i'm sure my absence must have been a relief :-) ]
>
> I have a request and 'am hoping that there *already* exists a solution so
> that I trouble Randy *very little *
>
>
> What am I looking for :
> ------------
> * As most of you know Benjamin Graham the guru of value investing
> advocated buying great value stocks cheap or say at a discount to value.
>
> * He had a few screens to decide on "value" and then couple of formulate
> to decide cheap / not so cheap
>
> * I wish to download this data [as advised by Graham] once in say 3 months
> or so & extract them to a worksheet ... NOT update every time the sp sheet
> opens, but one time download and save [and the rest of working I should be
> able to do on the WS ]
>
> * I visited the files section of this group thinking that there should be
> a ready made XL file that already provided graham #s
>
> * I could NOT find it
>
> * I found this 10 year XL sheet http://bit.ly/
> to say the least , but I am looking at a list with the ticker on the left
> extreme column and data on the rest of the columns ...something like this
> sheet http://bit.ly/
> something to download the data, NOT update every time
>
> Request :
> ------------
> Could I request Randy and others to help me with getting the following
> data of listed stocks in a table . Ticker on left extreme column, rest on
> the columns to the right , one time download every three months
>
> Better still, to avoid hitting servers often IF there is some data that is
> say within 1 month old, please mail / post the same and I'll use it
>
>
> Specifics about "..What am I looking for.." /
> and what did Benjamin Graham say
> ------------
>
> For each item I have listed what I am looking for followed byBenjamin
> Graham's distilled wisdom
>
>
> 1. What am I looking for = Market Cap
>
> Ben Graham = "Adequate"
> "vicissitudes&
> those days, In my XL sheet I plan to inflate it to accommodate the money
> printing ]
>
>
> 2. What am I looking for = Current Ratio
> 2.1. Value of Total Current assets [for total enterprise]
> 2.2. Value of long term debt [for total enterprise]
>
> Ben Graham = Strong financial condition, measured by current ratios that
> exceed two and net current assets that exceed long term debt;
>
>
> 3. Net profit for the last 10 years
>
> Ben Graham = Earnings stability, measured by 10 consecutive years of
> positive earnings;
>
>
> 4. Dividends paid over the last 10 years
>
> Ben Graham = A dividend record of uninterrupted payments for at least 20
> years; [Subu's note ... yeah it should be 20 years, but I guess going back
> 20 is tough ...so I'm diluting it here ... bad ...but ok for the moment]
>
>
> 5. EPS today ; EPS 10 years ago
>
> Ben Graham = Earnings-per-
> ten years;
>
>
> 6. PE Ratio
>
> Ben Graham = Moderate price-to-earnings ratios, which typically should not
> exceed 15; and
>
>
> 7. Price to book ratio
>
> Ben Graham = Moderate price-to-book ratios, which typically should not
> exceed 1½.
>
Thu Mar 28, 2013 3:27 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I know I saw a message awhile back on controlling the addin updating
elements start initial open. But I can't find it in the messages.
Can you point me to the message and how to find it in the future?
I would, also, like to control the addin from retrieving the information
from the webpage during testing until I am ready to test.
Anyway to do both?
Kermit
elements start initial open. But I can't find it in the messages.
Can you point me to the message and how to find it in the future?
I would, also, like to control the addin from retrieving the information
from the webpage during testing until I am ready to test.
Anyway to do both?
Kermit
Thu Mar 28, 2013 6:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Is this the one you're looking for?
http://finance.groups.yahoo.com/group/smf_addin/message/21417
For things that I want to see open as they were on the previous use, I'm
tending to modify my regular function usage to be smfUpdateDownloadTable.
On Thu, Mar 28, 2013 at 3:27 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> Randy, I know I saw a message awhile back on controlling the addinupdating elements start initial open. But I can't find it in the messages.
> ****
>
> ** **
>
> Can you point me to the message and how to find it in the future? ****
>
> ** **
>
> I would, also, like to control the addin from retrieving the information
> from the webpage during testing until I am ready to test. ****
>
> ** **
>
> Anyway to do both?****
>
>
>
http://finance.
For things that I want to see open as they were on the previous use, I'm
tending to modify my regular function usage to be smfUpdateDownloadTa
On Thu, Mar 28, 2013 at 3:27 PM, Kermit W. Prather
<kermitp@tampabay.
>
> Randy, I know I saw a message awhile back on controlling the addinupdating elements start initial open. But I can't find it in the messages.
> ****
>
> ** **
>
> Can you point me to the message and how to find it in the future? ****
>
> ** **
>
> I would, also, like to control the addin from retrieving the information
> from the webpage during testing until I am ready to test. ****
>
> ** **
>
> Anyway to do both?****
>
>
>
Thu Mar 28, 2013 1:03 pm (PDT) . Posted by:
"अनन्त:"
I was trying to get company description as below
=RCHGetElementNumber("AAPL",1)
to get the current price
=RCHGetElementNumber("AAPL",25)
52 week high
=RCHGetElementNumber("AAPL",34)
52 week low
=RCHGetElementNumber("AAPL",33)
Above shown elements are giving me "error"
however its getting other data from advfn fine Can someone please tell me
what am i doing wrong.
I would appreciate your help
=RCHGetElementNumbe
to get the current price
=RCHGetElementNumbe
52 week high
=RCHGetElementNumbe
52 week low
=RCHGetElementNumbe
Above shown elements are giving me "error"
however its getting other data from advfn fine Can someone please tell me
what am i doing wrong.
I would appreciate your help
Thu Mar 28, 2013 1:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You probably have an old definition of MSN elements. Are you running with
the latest release of the add-in? It will have the new element definitions.
On Thu, Mar 28, 2013 at 12:23 PM, अनन्त: <1998chemie@gmail.com > wrote:
>
> I was trying to get company description as below
> =RCHGetElementNumber("AAPL",1)
>
> to get the current price
> =RCHGetElementNumber("AAPL",25)
>
> 52 week high
> =RCHGetElementNumber("AAPL",34)
>
> 52 week low
> =RCHGetElementNumber("AAPL",33)
>
> Above shown elements are giving me "error"
> however its getting other data from advfn fine Can someone please tell me
> what am i doing wrong.
>
> I would appreciate your help
>
the latest release of the add-in? It will have the new element definitions.
On Thu, Mar 28, 2013 at 12:23 PM, अनन्त: <1998chemie@gmail.
>
> I was trying to get company description as below
> =RCHGetElementNumbe
>
> to get the current price
> =RCHGetElementNumbe
>
> 52 week high
> =RCHGetElementNumbe
>
> 52 week low
> =RCHGetElementNumbe
>
> Above shown elements are giving me "error"
> however its getting other data from advfn fine Can someone please tell me
> what am i doing wrong.
>
> I would appreciate your help
>
Fri Mar 29, 2013 12:03 am (PDT) . Posted by:
"weekeewawa" weekeewawa
Hello randy
It seems today I experienced some problem while updating msn.
Parts such as income statement balance sheet along with EArning per share works for 10 year history.
I noticed that in some post u recommended to update the latest version of smf
The latest version that I had was 2.1.2012 and that's the one that causes
Me proble
Does the latest version that u refer is in the work In progress file?
It seems today I experienced some problem while updating msn.
Parts such as income statement balance sheet along with EArning per share works for 10 year history.
I noticed that in some post u recommended to update the latest version of smf
The latest version that I had was 2.1.2012 and that's the one that causes
Me proble
Does the latest version that u refer is in the work In progress file?
Tidak ada komentar:
Posting Komentar