8 Messages
Digest #3197
3b
Re: RCHGetElementNumber(ticker,886) returns error message with other by "Randy Harmelink" rharmelink
Messages
Wed Oct 1, 2014 11:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031
Element #63 should NOT be returning #VALUE!. You must be dividing it by 100
to get it into a percentage amount? When "Error" gets returned from element
#63, dividing that by 100 would cause a #VALUE! error.
You can get that value from Reuters with element #13674.
On Wed, Oct 1, 2014 at 10:50 AM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Why is:
>
> RCHGetElementNumber(ticker , 63) (5 year dividend growth) returning #value
> ?
>
> If it has to do with MSN is there another way to get the dividend growth%?
> Thanks.
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031
Element #63 should NOT be returning #VALUE!. You must be dividing it by 100
to get it into a percentage amount? When "Error" gets returned from element
#63, dividing that by 100 would cause a #VALUE! error.
You can get that value from Reuters with element #13674.
On Wed, Oct 1, 2014 at 10:50 AM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Why is:
>
> RCHGetElementNumber
> ?
>
> If it has to do with MSN is there another way to get the dividend growth%?
> Thanks.
>
Wed Oct 1, 2014 12:34 pm (PDT) . Posted by:
zbgb952
Hello Randy,
Can you give me an example link to Reuters that shows the 5 yr dividend growth of a stock? thx
Can you give me an example link to Reuters that shows the 5 yr dividend growth of a stock? thx
Wed Oct 1, 2014 1:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can always get it yourself with:
=RCHGetElementNumber("P-URL",13674)
...which tells the function to return the URL parameter (or formula) being
used for the element, and returns:
http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~
Just substitute a ticker symbol for the "~~~~~", as in:
http://www.reuters.com/finance/stocks/financialHighlights?symbol=MMM
On Wed, Oct 1, 2014 at 12:34 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Can you give me an example link to Reuters that shows the 5 yr dividend
> growth of a stock? thx
>
>
=RCHGetElementNumber("P-URL",13674)
...which tells the function to return the URL parameter (or formula) being
used for the element, and returns:
http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~
Just substitute a ticker symbol for the "~~~~~", as in:
http://www.reuters.com/finance/stocks/financialHighlights?symbol=MMM
On Wed, Oct 1, 2014 at 12:34 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Can you give me an example link to Reuters that shows the 5 yr dividend
> growth of a stock? thx
>
>
Wed Oct 1, 2014 2:13 pm (PDT) . Posted by:
zbgb952
Hello Randy, where can I find a readable file that defines all the element numbers used
in RCHGetElementNumber ? I found the .txt files but they are very hard to read. You used to have these somewhere but things have changed since I last looked at this. Thanks.
in RCHGetElementNumber ? I found the .txt files but they are very hard to read. You used to have these somewhere but things have changed since I last looked at this. Thanks.
Wed Oct 1, 2014 2:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The XLS file distributed within the ZIP archives contains a database of all
the elements. You can easily use EXCEL's filter feature to find things.
On Wed, Oct 1, 2014 at 2:13 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Hello Randy, where can I find a readable file that defines all the element
> numbers used
> in RCHGetElementNumber ? I found the .txt files but they are very hard to
> read. You used to have these somewhere but things have changed since I last
> looked at this. Thanks.
>
the elements. You can easily use EXCEL's filter feature to find things.
On Wed, Oct 1, 2014 at 2:13 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Hello Randy, where can I find a readable file that defines all the element
> numbers used
> in RCHGetElementNumber ? I found the .txt files but they are very hard to
> read. You used to have these somewhere but things have changed since I last
> looked at this. Thanks.
>
Wed Oct 1, 2014 8:15 pm (PDT) . Posted by:
zbgb952
Hello Randy, i just tried inserting RCHGetelementNumber for 886, 887 and 887 (Morningstar
fair value estimate, consider buying price and consider sellilng price) and all show 'error' for all the tickers on my spreadsheet. Are these still valid? Why the error msg's? Thx.
fair value estimate, consider buying price and consider sellilng price) and all show 'error&#
Wed Oct 1, 2014 8:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Those are proprietary data items. You need to be a paid member and have the
IE security cookie created before you can access them.
I just tried them and they're working here.
On Wed, Oct 1, 2014 at 8:15 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Hello Randy, i just tried inserting RCHGetelementNumber for 886, 887 and
> 887 (Morningstar
> fair value estimate, consider buying price and consider sellilng price)
> and all show 'error' for all the tickers on my spreadsheet. Are these still
> valid? Why the error msg's? Thx.
>
IE security cookie created before you can access them.
I just tried them and they're working here.
On Wed, Oct 1, 2014 at 8:15 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Hello Randy, i just tried inserting RCHGetelementNumber for 886, 887 and
> 887 (Morningstar
> fair value estimate, consider buying price and consider sellilng price)
> and all show 'error&#
> valid? Why the error msg's? Thx.
>
Wed Oct 1, 2014 8:36 pm (PDT) . Posted by:
zbgb952
Well, I'm not a paid Morningstar member...
don't plan to be..thanks
don't plan to be..thanks
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar