10 New Messages
Digest #2866
2a
Re: How to get ROE and other fundamental data from Yahoo Finance sta by "Randy Harmelink" rharmelink
Messages
Wed Nov 20, 2013 3:44 pm (PST) . Posted by:
"lund355@bellsouth.net" lund355@bellsouth.net
Hi Randy and the smf_addin Group,
Thank you Randy for the great contribution and support on smf and RCH. I like your solution because it is open and supported.
I have been evaluating portfolio and stock tracking software for the PC. Ran into several difficulties implementing in Excel 2013. It is lacks some backward compatibility. My ability with Excel is out of date and have not found a good free source for the specific training I need.
While learning about your add-ins, I came across PowerPivot repeatedly. I mistakenly thought it was an advanced wizard for Pivot Tables. But it turns out to be a means of retrieving data from may types of external sources. It can relate data from several tables. A form of relational database. It appears to me that it could do what your add-ins do. Hence the question.
Hoping you have looked at this feature, What is your opinion of using the RCH add-ins versus PowerPivot?
It appears that support for RCH is growing as more sources come on line and as each source evolves. Does one add-in have an advantage over the other? Say, as to free data and subscribed data?
I'am somewhat of a newbie and looking for a direction to expend my training time.
Thank You,
GarryDL
Thank you Randy for the great contribution and support on smf and RCH. I like your solution because it is open and supported.
I have been evaluating portfolio and stock tracking software for the PC. Ran into several difficulties implementing in Excel 2013. It is lacks some backward compatibility. My ability with Excel is out of date and have not found a good free source for the specific training I need.
While learning about your add-ins, I came across PowerPivot repeatedly. I mistakenly thought it was an advanced wizard for Pivot Tables. But it turns out to be a means of retrieving data from may types of external sources. It can relate data from several tables. A form of relational database. It appears to me that it could do what your add-ins do. Hence the question.
Hoping you have looked at this feature, What is your opinion of using the RCH add-ins versus PowerPivot?
It appears that support for RCH is growing as more sources come on line and as each source evolves. Does one add-in have an advantage over the other? Say, as to free data and subscribed data?
I'am somewhat of a newbie and looking for a direction to expend my training time.
Thank You,
GarryDL
Wed Nov 20, 2013 3:55 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Your message is the first I've heard of PowerPivot. It appears to be for
version of EXCEL beyond what I have.
On Wed, Nov 20, 2013 at 9:23 AM, lund355@bellsouth.net <
lund355@bellsouth.net> wrote:
> Hi Randy and the smf_addin Group,
>
> Thank you Randy for the great contribution and support on smf and RCH. I
> like your solution because it is open and supported.
>
> I have been evaluating portfolio and stock tracking software for the PC.
> Ran into several difficulties implementing in Excel 2013. It is lacks some
> backward compatibility. My ability with Excel is out of date and have not
> found a good free source for the specific training I need.
>
> While learning about your add-ins, I came across PowerPivot repeatedly. I
> mistakenly thought it was an advanced wizard for Pivot Tables. But it
> turns out to be a means of retrieving data from may types of external
> sources. It can relate data from several tables. A form of relational
> database. It appears to me that it could do what your add-ins do. Hence the
> question.
>
> Hoping you have looked at this feature, What is your opinion of using the
> RCH add-ins versus PowerPivot?
>
> It appears that support for RCH is growing as more sources come on line
> and as each source evolves. Does one add-in have an advantage over the
> other? Say, as to free data and subscribed data?
>
> I'am somewhat of a newbie and looking for a direction to expend my
> training time.
>
version of EXCEL beyond what I have.
On Wed, Nov 20, 2013 at 9:23 AM, lund355@bellsouth.
lund355@bellsouth.
> Hi Randy and the smf_addin Group,
>
> Thank you Randy for the great contribution and support on smf and RCH. I
> like your solution because it is open and supported.
>
> I have been evaluating portfolio and stock tracking software for the PC.
> Ran into several difficulties implementing in Excel 2013. It is lacks some
> backward compatibility. My ability with Excel is out of date and have not
> found a good free source for the specific training I need.
>
> While learning about your add-ins, I came across PowerPivot repeatedly. I
> mistakenly thought it was an advanced wizard for Pivot Tables. But it
> turns out to be a means of retrieving data from may types of external
> sources. It can relate data from several tables. A form of relational
> database. It appears to me that it could do what your add-ins do. Hence the
> question.
>
> Hoping you have looked at this feature, What is your opinion of using the
> RCH add-ins versus PowerPivot?
>
> It appears that support for RCH is growing as more sources come on line
> and as each source evolves. Does one add-in have an advantage over the
> other? Say, as to free data and subscribed data?
>
> I'am somewhat of a newbie and looking for a direction to expend my
> training time.
>
Wed Nov 20, 2013 4:20 pm (PST) . Posted by:
"lund355@bellsouth.net" lund355@bellsouth.net
I believe PowerPivot was introduced with 2010 as a free download. Not available with RT.
Garry
Garry
Wed Nov 20, 2013 4:42 pm (PST) . Posted by:
"lund355@bellsouth.net" lund355@bellsouth.net
Just found a download and tutorial on Power Pivot:
http://powerpivotsdr.codeplex.com/
I'll be trying this out.
Garry
http://powerpivotsd
I'll be trying this out.
Garry
Wed Nov 20, 2013 5:25 pm (PST) . Posted by:
"Jonathan Krummel" jon.krummel
Hi I recent got this add in and love it. But you guys send a ton of emails. Is there a way to turn off emails without leaving group?
> On Nov 20, 2013, at 5:55 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
>
> Your message is the first I've heard of PowerPivot. It appears to be for version of EXCEL beyond what I have.
>
>> On Wed, Nov 20, 2013 at 9:23 AM, lund355@bellsouth.net <lund355@bellsouth.net> wrote:
>> Hi Randy and the smf_addin Group,
>>
>> Thank you Randy for the great contribution and support on smf and RCH. I like your solution because it is open and supported.
>>
>> I have been evaluating portfolio and stock tracking software for the PC. Ran into several difficulties implementing in Excel 2013. It is lacks some backward compatibility. My ability with Excel is out of date and have not found a good free source for the specific training I need.
>>
>> While learning about your add-ins, I came across PowerPivot repeatedly. I mistakenly thought it was an advanced wizard for Pivot Tables. But it turns out to be a means of retrieving data from may types of external sources. It can relate data from several tables. A form of relational database. It appears to me that it could do what your add-ins do. Hence the question.
>>
>> Hoping you have looked at this feature, What is your opinion of using the RCH add-ins versus PowerPivot?
>>
>> It appears that support for RCH is growing as more sources come on line and as each source evolves. Does one add-in have an advantage over the other? Say, as to free data and subscribed data?
>>
>> I'am somewhat of a newbie and looking for a direction to expend my training time.
>
>
> On Nov 20, 2013, at 5:55 PM, Randy Harmelink <rharmelink@gmail.
>
> Your message is the first I've heard of PowerPivot. It appears to be for version of EXCEL beyond what I have.
>
>> On Wed, Nov 20, 2013 at 9:23 AM, lund355@bellsouth.
>> Hi Randy and the smf_addin Group,
>>
>> Thank you Randy for the great contribution and support on smf and RCH. I like your solution because it is open and supported.
>>
>> I have been evaluating portfolio and stock tracking software for the PC. Ran into several difficulties implementing in Excel 2013. It is lacks some backward compatibility. My ability with Excel is out of date and have not found a good free source for the specific training I need.
>>
>> While learning about your add-ins, I came across PowerPivot repeatedly. I mistakenly thought it was an advanced wizard for Pivot Tables. But it turns out to be a means of retrieving data from may types of external sources. It can relate data from several tables. A form of relational database. It appears to me that it could do what your add-ins do. Hence the question.
>>
>> Hoping you have looked at this feature, What is your opinion of using the RCH add-ins versus PowerPivot?
>>
>> It appears that support for RCH is growing as more sources come on line and as each source evolves. Does one add-in have an advantage over the other? Say, as to free data and subscribed data?
>>
>> I'am somewhat of a newbie and looking for a direction to expend my training time.
>
>
Wed Nov 20, 2013 5:26 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Go to your membership settings:
http://groups.yahoo.com/neo/groups/smf_addin/management/membership
...and change your "Message Delivery" setting to either "No Email" or
"Special Notices".
On Wed, Nov 20, 2013 at 5:30 PM, Jonathan Krummel <jon.krummel@yahoo.com>wrote:
>
> Hi I recent got this add in and love it. But you guys send a ton of
> emails. Is there a way to turn off emails without leaving group?
>
http://groups.
...and change your "Message Delivery" setting to either "No Email" or
"Special Notices"
On Wed, Nov 20, 2013 at 5:30 PM, Jonathan Krummel <jon.krummel@
>
> Hi I recent got this add in and love it. But you guys send a ton of
> emails. Is there a way to turn off emails without leaving group?
>
Wed Nov 20, 2013 3:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yahoo doesn't offer those items on the CSV feed, so RCHGetYahooQuotes()
isn't going to be of help.
The documentation on RCHGetYahooQuotes() has all of the Yahoo codes I'm
aware of. Even some that Yahoo has deprecated, which may become active
again.
On Wed, Nov 20, 2013 at 9:01 AM, <nuno.nogueira35@gmail.com> wrote:
>
> I'm using =RCHGetYahooQuotes("IBM","j1") to get the market cap of IBM.
> Now I need to get other data, like:
>
> - ROE
> - ROA
> - Revenue
> - Total Debt
> - etc
>
> I'm using the lite version of RHCGetYahooQuotes, so no add-in. Where can I
> find the complete list of symbols to get these data points?
>
isn't going to be of help.
The documentation on RCHGetYahooQuotes(
aware of. Even some that Yahoo has deprecated, which may become active
again.
On Wed, Nov 20, 2013 at 9:01 AM, <nuno.nogueira35@
>
> I'm using =RCHGetYahooQuotes(
> Now I need to get other data, like:
>
> - ROE
> - ROA
> - Revenue
> - Total Debt
> - etc
>
> I'm using the lite version of RHCGetYahooQuotes, so no add-in. Where can I
> find the complete list of symbols to get these data points?
>
Wed Nov 20, 2013 3:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's not a field I deal with, so I don't recall anything that is prebuilt.
On Wed, Nov 20, 2013 at 11:19 AM, <johkouf@hotmail.com> wrote:
> Do you also know whicj element returns the Country ?
>
On Wed, Nov 20, 2013 at 11:19 AM, <johkouf@hotmail.
> Do you also know whicj element returns the Country ?
>
Wed Nov 20, 2013 3:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
They have (or used to have) more years on some companies, but four seems to
be the norm.
On Wed, Nov 20, 2013 at 12:28 PM, <joe.casino@yahoo.com> wrote:
> However, I do notice that the data only goes four years back, and then I
> get an error message. Is that as far back as Google will go, or is that
> something you are still working on in the element definitions?
>
>
be the norm.
On Wed, Nov 20, 2013 at 12:28 PM, <joe.casino@yahoo.
> However, I do notice that the data only goes four years back, and then I
> get an error message. Is that as far back as Google will go, or is that
> something you are still working on in the element definitions?
>
>
Wed Nov 20, 2013 8:18 pm (PST) . Posted by:
hamishthedenizen
Fixes done - thanks for pointing them out (and thanks to Randy, who made all of this possible).
Apologies for all the bugs, I've just been flat out on other projects.GuruFocus appears to be making minor tweaks to the layout so some of the fields may change over time.
It would be possible to build something dynamic that pulls the row titles in from the website rather than hardcoding them as I have, but that might be an issue for people who are setting up formulae that need to refer to specific rows. A project for another day.
---In smf_addin@yahoogroups.com, <dcharlotte99@...> wrote:
A big thank you to dancarroll/hamisthedenizen and of course Randy for the GuruFocus 10-year model. I've QC'ed the version on the 'Uploads' section and have the following relatively minor comments:
Income Statement: Added a row to collect 'EPS (Basic)'
Income Statement: Corrected first few columns of row 8 to have it pull from website
Cashflow Statement: for Net Income changed columns 2 and 3 to pull from other ss cell
Cashflow Statement: Changed title in Column B of 'Deferred Taxes' to 'Sale of Property, Plant, Equipment' to match website and pull data
I QC'd much of the data also. Thanks again!
Apologies for all the bugs, I've just been flat out on other projects.GuruFocus appears to be making minor tweaks to the layout so some of the fields may change over time.
It would be possible to build something dynamic that pulls the row titles in from the website rather than hardcoding them as I have, but that might be an issue for people who are setting up formulae that need to refer to specific rows. A project for another day.
---In smf_addin@yahoogrou
A big thank you to dancarroll/hamisthe
Income Statement: Added a row to collect 'EPS (Basic)'
Income Statement: Corrected first few columns of row 8 to have it pull from website
Cashflow Statement: for Net Income changed columns 2 and 3 to pull from other ss cell
Cashflow Statement: Changed title in Column B of 'Deferred Taxes' to 'Sale of Property, Plant, Equipment' to match website and pull data
I QC'd much of the data also. Thanks again!
Tidak ada komentar:
Posting Komentar