Calculating Fidelity fundamentals such as Forward P/E , Return on Sales, PEG
Author: bompus
Creation Date: 2/1/2011 1:19 PM
profile picture

bompus

#1
I've been hammering the script hard and cannot seem to figure out what I am doing wrong. I am new to WealthScript, so if it is simple, understand I am a newbie with it :)

---
I am trying to calculate Forward P/E this way:
CODE:
Please log in to see this code.


However, this yields me a "Forward P/E" on GOOG (as of today's date) of: 74.1459 , which does not match up to anything I can find
---

---
Return on Sales attempt:
CODE:
Please log in to see this code.


Again, seems not accurate compared to data on Yahoo/Fidelity.com/etc
---

---
PEG attempt:
CODE:
Please log in to see this code.


It seems like no matter what symbol I try it against, EarningsGrowthRateYr is always "0". If I try to use the quarterly flag with GrowthRateSeries, it gives me a result, but with the yearly flag, I am getting "0", which makes it difficult to calculate PEG since this is needed.
---

Hope you guys can help! Thanks a ton.
profile picture

Cone

#2
CODE:
Please log in to see this code.


Also, run the example in the QuickRef (F12) for FundamentalDataItems, and replace "assets" with "estimated earnings". Look at the debug log to see the info that's available.
profile picture

bompus

#3
I'm still having a very difficult time calculating a proper PEG ratio that comes anywhere close to the PEG numbers I see on financial sites.

Tried IBM and I get:

0.93 and 2.61 depending on how I try to calculate it.

Tried the following to get an accurate PEG and can't seem to find it:

CODE:
Please log in to see this code.


Any ideas?
profile picture

Cone

#4
Please post the WealthScript code you used for your calculations.
profile picture

bompus

#5
CODE:
Please log in to see this code.


I've tried almost every combination of different P/E ratios and EPS Growth Ratios and never can come up with a reliable PEG ratio (compared to Yahoo/Zacks/Fidelity.com/Nasdaq/etc) .. I think some of them use a 5 year projected EPS growth rate, but even with that, my values are way off... I'm not the greatest at formula's or math, so I appreciate the help.

Thanks Cone!
profile picture

Cone

#6
After updating price and fundamental data, for IBM I get P/E = 13.82, current PEG = 2.87, and optimistic PEG = 2.05. If it's wrong, then the data must be wrong. Check the input fundamental data using the FundamentalDataItems technique (see my first post).

CODE:
Please log in to see this code.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).