Registered User Joined: 1/27/2005 Posts: 3
|
Dear Sirs, I would like to create a list of symbols in Excel (which I've done) then get the highest high and lowest low prices for those stocks for 2005 from the Telechart. When 2006 arrives I would then get the highs and lows for just 2006. Can you help me with a list of instructions to do this.
Thanks for all your hard work.
(email removed by Moderator)
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
There really isn't a straightforward way to do this using TeleChart's Personal Criteria Formula Language. If you are already exporting to Excel, it is possible to use its functions however.
I can't really provide an Excel tutorial, but if you create a second Worksheet in your Workbook, it is fairly straightforward to create formulas in your first worksheet referencing the second that would calculate the High's and Low's for each Calendar Year. The second Worksheet would be based on an Export to text as a single file including all the dates you need with at a minimum Symbol, High, Low and Date (preferably in YYYYMMDD format).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|