investor0329 wrote: > > I just started using the QP_HighPE and QP_LowPE Excel functions > thinking they would be useful in identifying low priced stocks but i > see problems with these.. > > For exampe.. > > ticker: HBIO which QP has data for since 12/7/2000.... > The current p/e is given as 20. The QP_LowPE function yields > 5.19, however, the QP_HighPE function yields 0.00 !! Why is this? >
If you use "Display Charts" | "Fundamental Data " for HIBO you will see the same values as you found with your QP_LowPE and QP_HighPE Functions. Hence it is obvious your functions are reporting the values it found in the Quotes Plus Database. I am not surprised there is a lot of missing fundamental data or fundamental data that is in error in the Quotes Plus Database. Given the time constraints and number of issues in the Quotes Plus Database about all Gary can do is distribute the data he receives from his supplier. That is if Gary receives bad data from his supplier you will see bad data in the Quotes Plus Database. An alternate source for fundamental data is "Value Line" at your local library. Howard > There has to be a high pe is there is a low pe..even if it is the > current p/e and the current p/e is higher than the low p/e..so this > makes zero sense to me. > > Also, there are lots of cases where the current p/e is negative yet > the low p/e is given as 0. > > And of course, most stocks have a 0 for both low and high p/e...not > too useful. > > Please advise. > > Thx. > >
