Kamis, 02 Oktober 2014

[smf_addin] Digest Number 3197

8 Messages

Digest #3197

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.
>

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

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
>
>

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.


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.
>

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&#39; for all the tickers on my spreadsheet. Are these still valid? Why the error msg's? Thx.


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&#39; for all the tickers on my spreadsheet. Are these still
> 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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar