Messages In This Digest (8 Messages)
- 1a.
- scrolling graph From: george
- 1b.
- Re: scrolling graph From: Randy Harmelink
- 2a.
- Combining elements From: Jason
- 2b.
- Re: Combining elements From: Randy Harmelink
- 2c.
- Re: Combining elements From: J@Y
- 2d.
- Re: Combining elements From: Randy Harmelink
- 3a.
- Need help 'cause of changes to what MSN returns From: Ryalmokas
- 3b.
- Re: Need help 'cause of changes to what MSN returns From: Randy Harmelink
Messages
- 1a.
-
scrolling graph
Posted by: "george" landgstewart@yahoo.com landgstewart
Sat Apr 7, 2012 9:26 am (PDT)
I have 3 excel columns with five thousand plus rows of entries
and want to use the data to create a scrolling line graph to prove
trends . I am using 2007 any direction greatly appreciated...
- 1b.
-
Re: scrolling graph
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Apr 7, 2012 10:04 am (PDT)
Go to http://www.oaltd.co.uk/Excel/ and get the FunChrt7.zipDefault.htm
file. It has an excellent example of creating a scrolling chart.
On Sat, Apr 7, 2012 at 9:22 AM, george <landgstewart@yahoo.com > wrote:
> I have 3 excel columns with five thousand plus rows of entries
> and want to use the data to create a scrolling line graph to prove
> trends . I am using 2007 any direction greatly appreciated...
>
- 2a.
-
Combining elements
Posted by: "Jason" xxjaysonxx@aol.com g3m1n1980
Sat Apr 7, 2012 10:52 am (PDT)
Is there a way to combine numbers so the returned element shows up in one cell?
Example:
=RCHGetElementNumber('Ticker Input'!B3,(333* 990))
I looked to easily multiple 333 and 990 to calculate dividends per share but I seem to get an error.
Thanks
- 2b.
-
Re: Combining elements
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Apr 7, 2012 11:02 am (PDT)
You would do it just as you would any other EXCEL function:
=RCHGetElementNumber('Ticker Input'!B3,333) *RCHGetElementNu mber('Ticker
Input'!B3,990)
On a separate note, it's not usually a good idea to mix elements like that,
from different data sources. The timings and definitions can sometimes be
mismatched.
Also, multiplying EPS and Yield will not give you dividends per share. That
would just be yield times stock price.
I'm not even sure why you would do such a calculation, since there are
elements from the same Yahoo Key Statistics page that give you either the
trailing or the forward dividends per share.
On Sat, Apr 7, 2012 at 10:43 AM, Jason <xxjaysonxx@aol.com > wrote:
> Is there a way to combine numbers so the returned element shows up in one
> cell?
>
> Example:
> =RCHGetElementNumber('Ticker Input'!B3,(333* 990))
>
> I looked to easily multiple 333 and 990 to calculate dividends per share
> but I seem to get an error.
>
- 2c.
-
Re: Combining elements
Posted by: "J@Y" xxjaysonxx@aol.com g3m1n1980
Sat Apr 7, 2012 11:31 am (PDT)
Thank you Randy.
I was calculating annual dividends paid to common stock / number of common shares outstanding which I thought was EPS x Dividend payout ratio (amount of dividends paid to common stockholder).
Maybe I listed the wrong numbers but I didnt think you had one source for this.
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin <smf_addin@yahoogroups.com >
Sent: Sat, Apr 7, 2012 2:02 pm
Subject: Re: [smf_addin] Combining elements
You would do it just as you would any other EXCEL function:
=RCHGetElementNumber('Ticker Input'!B3,333) *RCHGetElementNu mber('Ticker Input'!B3,990)
On a separate note, it's not usually a good idea to mix elements like that, from different data sources. The timings and definitions can sometimes be mismatched.
Also, multiplying EPS and Yield will not give you dividends per share. That would just be yield times stock price.
I'm not even sure why you would do such a calculation, since there are elements from the same Yahoo Key Statistics page that give you either the trailing or the forward dividends per share.
On Sat, Apr 7, 2012 at 10:43 AM, Jason <xxjaysonxx@aol.com > wrote:
Is there a way to combine numbers so the returned element shows up in one cell?
Example:
=RCHGetElementNumber('Ticker Input'!B3,(333* 990))
I looked to easily multiple 333 and 990 to calculate dividends per share but I seem to get an error.
- 2d.
-
Re: Combining elements
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Apr 7, 2012 1:08 pm (PDT)
Earnings have nothing to do with dividends. Dividends can be more than the
amount of earnings. But the dividend YIELD is based on the stock price.
Your best bet would be to search for a source of total dividends paid. I
would think AdvFN would have that value.
On Sat, Apr 7, 2012 at 11:31 AM, J@Y <xxjaysonxx@aol.com > wrote:
> I was calculating annual dividends paid to common stock / number of
> common shares outstanding which I thought was EPS x Dividend payout ratio
> (amount of dividends paid to common stockholder).
> Maybe I listed the wrong numbers but I didnt think you had one source
> for this.
>
>
- 3a.
-
Need help 'cause of changes to what MSN returns
Posted by: "Ryalmokas" ryalmokas@hotmail.com Ryalmokas
Sat Apr 7, 2012 6:36 pm (PDT)
I use Excel 2007, although as you'll see from my question I'm not an advanced user. Today I decided to use one of my earlier financial workbooks, and one of the data elements I have been using comes from;
rchgetelementnumber (symbol, 302).
For a stock like IBM it would return $87,100,000,000; now it returns
$87.1 Bill, and my workbook chokes because of other formulae depending on the currency format rather than $87.1 Bill. Somewhere along the line MSN changed how it reports some fields.
Is there a way to take the $87.1 Bill and transform it to either a
numeric 87.1 or to currency of $87,100,000,000?
Thanks for any help offered,
Dick
- 3b.
-
Re: Need help 'cause of changes to what MSN returns
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Apr 7, 2012 8:03 pm (PDT)
I added " Bill" and " Mill" suffix conversions to the add-in. This beta
version can be found in the "Works in Progress" folder of the files area,
within RCH_Stock_Market_Functions- 2.1.2012. 04.07.zip.
Best practice is to exit EXCEL before updating add-in files.
On Sat, Apr 7, 2012 at 6:36 PM, Ryalmokas <ryalmokas@hotmail.com > wrote:
> I use Excel 2007, although as you'll see from my question I'm not an
> advanced user. Today I decided to use one of my earlier financial
> workbooks, and one of the data elements I have been using comes from;
> rchgetelementnumber (symbol, 302).
>
> For a stock like IBM it would return $87,100,000,000; now it returns
> $87.1 Bill, and my workbook chokes because of other formulae depending on
> the currency format rather than $87.1 Bill. Somewhere along the line MSN
> changed how it reports some fields.
>
> Is there a way to take the $87.1 Bill and transform it to either a
> numeric 87.1 or to currency of $87,100,000,000?
>
> Thanks for any help offered,
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar