8 Messages
Digest #2985
Messages
Thu Feb 27, 2014 6:19 am (PST) . Posted by:
rr76012
Randy, I found this conversation very useful. 2/27/2014
I am glad you explained how to replace older versions of smf-elements-5.txt.
I thought replacing the older smf folder automatically did all this, it turns out you need to update individual files occasionally.
Thanks for pointing this out.
Randy, Have a great week.
rr76012
I am glad you explained how to replace older versions of smf-elements-
I thought replacing the older smf folder automatically did all this, it turns out you need to update individual files occasionally.
Thanks for pointing this out.
Randy, Have a great week.
rr76012
Thu Feb 27, 2014 9:44 am (PST) . Posted by:
kevin_k_hatch
I am trying to use the RCHGetElementNumber() function to create some quick financial models using Google's data. Unfortunately there is no element number for accumulated depreciation or Net Property and Equipment for the balance sheets. How can I get this data to pull?
Thu Feb 27, 2014 9:55 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Just use the RCHGetTableCell() function. For example:
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=MMM",1,">Accumulated
Depreciation")
On Thu, Feb 27, 2014 at 8:42 AM, <kevin_k_hatch@yahoo.com> wrote:
>
> I am trying to use the RCHGetElementNumber() function to create some quick
> financial models using Google's data. Unfortunately there is no element
> number for accumulated depreciation or Net Property and Equipment for the
> balance sheets. How can I get this data to pull?
>
=RCHGetTableCell(
Depreciation"
On Thu, Feb 27, 2014 at 8:42 AM, <kevin_k_hatch@
>
> I am trying to use the RCHGetElementNumber
> financial models using Google's data. Unfortunately there is no element
> number for accumulated depreciation or Net Property and Equipment for the
> balance sheets. How can I get this data to pull?
>
Thu Feb 27, 2014 1:42 pm (PST) . Posted by:
kevin_k_hatch
This works great for pulling the quarterly data, what alterations would you have to make in order to pull the annual data?
Thu Feb 27, 2014 2:12 pm (PST) . Posted by:
kevin_k_hatch
Thanks! I am new to using the addin and am trying to figure things out still. One problem I have with that equation is that it pulls data off the quarterly page and not the annual. Is there another find parameter that must be added to pull the annual data?
Thu Feb 27, 2014 3:50 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
All three financial statements, annually and quarterly, are in the source
code of that same web page. The "links" you click on just change which
sections are hidden and which is display. For the annual balance sheet
data, you need to add another parameter to position the add-in just in
front of the annual data, before searching for line items within it:
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=MMM",1,"BALANNUALDIV",">Accumulated
Depreciation")
On Thu, Feb 27, 2014 at 3:12 PM, <kevin_k_hatch@yahoo.com> wrote:
>
> Thanks! I am new to using the addin and am trying to figure things out
> still. One problem I have with that equation is that it pulls data off the
> quarterly page and not the annual. Is there another find parameter that
> must be added to pull the annual data?
>
code of that same web page. The "links" you click on just change which
sections are hidden and which is display. For the annual balance sheet
data, you need to add another parameter to position the add-in just in
front of the annual data, before searching for line items within it:
=RCHGetTableCell(
Depreciation"
On Thu, Feb 27, 2014 at 3:12 PM, <kevin_k_hatch@
>
> Thanks! I am new to using the addin and am trying to figure things out
> still. One problem I have with that equation is that it pulls data off the
> quarterly page and not the annual. Is there another find parameter that
> must be added to pull the annual data?
>
Thu Feb 27, 2014 3:38 pm (PST) . Posted by:
"ALVARO PENA" mitresourcesinc
I am trying to find the Element Number for a stock Last Price. There is one from MSN but says Obsolete. Could you please help?
Thanks & regards,
Alvaro Pena
>
>
>
Thu Feb 27, 2014 3:41 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25385
On Thu, Feb 27, 2014 at 3:42 PM, ALVARO PENA <pena.alvaro@icloud.com> wrote:
>
> I am trying to find the Element Number for a stock Last Price. There is
> one from MSN but says Obsolete. Could you please help?
>
https://groups.
On Thu, Feb 27, 2014 at 3:42 PM, ALVARO PENA <pena.alvaro@
>
> I am trying to find the Element Number for a stock Last Price. There is
> one from MSN but says Obsolete. Could you please help?
>
Tidak ada komentar:
Posting Komentar