|
PureBytes Links
Trading Reference Links
|
Convert the daily received data file with the addition of the O/I field used for the P/E values.
This adding "O/I for P/E" can be easely done in Excel and when required also fully automated.
{Note: Your data provider is also capable to provide you with this type of file layout and daily values}.
Write a P/E exploration then as follows
ColA: C
ColB: ROC(data array,periods,diff_method)
ColC: OI
Filter: OI<20
Start the Exploration using enough periods
When finished click the Sort button
Right Click , Click Copy and Paste to whatever. Automate the daily Convert-job using
the FREE available ScriptIT and TaskManager programs and use these then in
combination with VBA for the Excel-macro. {see also my homepage}
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.
Homepage http://home.planet.nl/~anthmaas
----- Oorspronkelijk bericht -----
Van: "Bodo Brochterbeck" <Minotaurus007@xxxxxxx>
Aan: <metastock@xxxxxxxxxxxxx>
Verzonden: dinsdag 19 september 2000 20:13
Onderwerp: Use of fundamental data in Metastock?
> I want to do an exploration of all stock trading below a P/E-ratio of 20, sorted by ROC.
> How can I accomplish this?
>
>
|