| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 4/11/2007
Posts: 2
|
What I'm after is a way to get a numerical value that meaures the cost for each dollar of dividend per security. I don't see either the dividend amount nor yield in the PCF function list (is there an expanded data dictionary somewhere)?
Anyway, example:
Security currently trades at $13.91 per share
Dividend Yield is 9.92%
To get the dividend amount, reverse the yield equation:
$13.91 * .0992 or $1.38 (to nearest cent)
Now, to get the cost of $1 amount of dividend:
First: 1 / $1.38 = .7246
Cost per $ of dividend is: .7246 * $13.91 or $10.08 (rounded).
This now tells me that for around every $10 I invest in this security I'll get $1 worth of dividend.
Having this numerical value to sort dividend paying stocks by would allow me to see the most cost-effective dividend payers, as one criterion for consideration. So, how do I get there from here?
Thanks!
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
I don't think you can access dividends with the PCF language.
I would suggest you put price and dividend next to each
other in a watchlist tab. Sort by dividend. By looking you
should be able to find good relationships.
Instead of the calculation I would look at the ratio.
If a $14 stock has a 14% yield that is 1 to 1.
If a $14 stock has a 7% yield that's half.
You can flag good candidates. Put them in there own watchlist
and do the actual calculation in a spreadsheet.
Thanks
diceman
|
|
Registered User
Joined: 4/11/2007
Posts: 2
|
QUOTE (diceman) I don't think you can access dividends with the PCF language.
Thanks for the reply and suggestions. I suppose my larger question is for a more robust version of the PCF language where you can access all the system functions and use them in whatever way works best. Either that or perhaps I need a more comprehensive, if, ahem, also more expensive, software package that allows more programmability.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
You can do any type of calculations, scanning, back testing and manipulation of financial data (which, unlike TeleChart, is historical) in The Blocks Player.
To download The Block Player, please check out the Blocks Player Web Site
For information on the Modular Tools by Worden for the Blocks Player, check out the Web Site
For information, videos and to activate BackScanner, please check out the BackScanner Site
Best part? The Player is free and uses your TeleChart data!
- Craig
Here to Help!
|
|
Registered User
Joined: 10/18/2005
Posts: 49
|
QUOTE (diceman) ...
Sort by dividend. By looking you
should be able to find good relationships.
...
That will work, but note these two cautions:
1. TC has a problem with SMALL dividends.
For example, the ticker "KSW" -
current price about $8.00
current dividend $0.06.
TC reports this as 24.9%
You do the math.
My primitive math results in 0.75%.
You'll have to check each yield reported
manually!
2. Have you noticed, that several questions
about this topic have been ignored?
See post by "snowhawkp" on June 20, 07.
But they do suggest moving to blocks,
if you want to play with dividends.
Abair
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
Don't know why "KSW" would be so high.
(My guess is you would only have to check
ones that seem odd)
Another idea would be to create a spreadsheet
with dollar values from 5 to 100 dollars in 5
dollar increments in column A.
Then in column B you could put calculation
for 1% yield. C 2% yield. D 3% yield and so on.
Print in out and you will have a quick view of the
price dividend relationship.
Thanks
diceman
|
|
Registered User
Joined: 10/18/2005
Posts: 49
|
QUOTE (diceman) Don't know why "KSW" would be so high.
Dividing by a very small number does this sort of thing. Something in TC's calculation of dividend yield is faulty.
QUOTE (diceman)
(spreadsheet)
with dollar values from 5 to 100 dollars in 5
dollar increments in column A.
Then in column B you could put calculation
for 1% yield. C 2% yield. D 3% yield and so on.
Print in out and you will have a quick view of the
price dividend relationship.
The PERCENT YIELD already gives you a n EXACT price dividend relationship.
A $100 stock with a 5% dividend yield has the exact same cost per dollar dividend, that a $5 stock with a 5% dividend yield has.
Abair
|
|
|
Guest-1 |