Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Highs and lows for a particular year Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
106668
Posted : Friday, December 16, 2005 11:44:27 AM
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)
Bruce_L
Posted : Friday, December 16, 2005 12:15:50 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.