Welcome Guest, please sign in to participate in a discussion.

Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » re create PCF for standard deviation

re create PCF for standard deviation Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
docmba		Posted : Monday, August 1, 2005 2:42:10 PM
Gold Customer Joined: 10/7/2004 Posts: 17		As a Tcnet user I would like to know if you could create the pcf formula for standard deviation for any security going back up to 1yr of price entries If not ,could you steer me to where I can get help. Thankyou, username/number: docmba/ 135228# email (email removed by moderator)
Back to top
Bruce_L		Posted : Monday, August 1, 2005 2:50:52 PM
Worden Trainer Joined: 10/7/2004 Posts: 65,138		It is long enough that is probably best limited to use as a Personal Criteria Formula (and not suggested for use as a Custom Indicator), but try this: 250-Period Standard Deviation: SQR(((C-AVGC250)^2 +(C1-AVGC250)^2 +(C2-AVGC250)^2 +(C3-AVGC250)^2 +(C4-AVGC250)^2 +(C5-AVGC250)^2 +(C6-AVGC250)^2 +(C7-AVGC250)^2 +(C8-AVGC250)^2 +(C9-AVGC250)^2 +(C10-AVGC250)^2 +(C11-AVGC250)^2 +(C12-AVGC250)^2 +(C13-AVGC250)^2 +(C14-AVGC250)^2 +(C15-AVGC250)^2 +(C16-AVGC250)^2 +(C17-AVGC250)^2 +(C18-AVGC250)^2 +(C19-AVGC250)^2 +(C20-AVGC250)^2 +(C21-AVGC250)^2 +(C22-AVGC250)^2 +(C23-AVGC250)^2 +(C24-AVGC250)^2 +(C25-AVGC250)^2 +(C26-AVGC250)^2 +(C27-AVGC250)^2 +(C28-AVGC250)^2 +(C29-AVGC250)^2 +(C30-AVGC250)^2 +(C31-AVGC250)^2 +(C32-AVGC250)^2 +(C33-AVGC250)^2 +(C34-AVGC250)^2 +(C35-AVGC250)^2 +(C36-AVGC250)^2 +(C37-AVGC250)^2 +(C38-AVGC250)^2 +(C39-AVGC250)^2 +(C40-AVGC250)^2 +(C41-AVGC250)^2 +(C42-AVGC250)^2 +(C43-AVGC250)^2 +(C44-AVGC250)^2 +(C45-AVGC250)^2 +(C46-AVGC250)^2 +(C47-AVGC250)^2 +(C48-AVGC250)^2 +(C49-AVGC250)^2 +(C50-AVGC250)^2 +(C51-AVGC250)^2 +(C52-AVGC250)^2 +(C53-AVGC250)^2 +(C54-AVGC250)^2 +(C55-AVGC250)^2 +(C56-AVGC250)^2 +(C57-AVGC250)^2 +(C58-AVGC250)^2 +(C59-AVGC250)^2 +(C60-AVGC250)^2 +(C61-AVGC250)^2 +(C62-AVGC250)^2 +(C63-AVGC250)^2 +(C64-AVGC250)^2 +(C65-AVGC250)^2 +(C66-AVGC250)^2 +(C67-AVGC250)^2 +(C68-AVGC250)^2 +(C69-AVGC250)^2 +(C70-AVGC250)^2 +(C71-AVGC250)^2 +(C72-AVGC250)^2 +(C73-AVGC250)^2 +(C74-AVGC250)^2 +(C75-AVGC250)^2 +(C76-AVGC250)^2 +(C77-AVGC250)^2 +(C78-AVGC250)^2 +(C79-AVGC250)^2 +(C80-AVGC250)^2 +(C81-AVGC250)^2 +(C82-AVGC250)^2 +(C83-AVGC250)^2 +(C84-AVGC250)^2 +(C85-AVGC250)^2 +(C86-AVGC250)^2 +(C87-AVGC250)^2 +(C88-AVGC250)^2 +(C89-AVGC250)^2 +(C90-AVGC250)^2 +(C91-AVGC250)^2 +(C92-AVGC250)^2 +(C93-AVGC250)^2 +(C94-AVGC250)^2 +(C95-AVGC250)^2 +(C96-AVGC250)^2 +(C97-AVGC250)^2 +(C98-AVGC250)^2 +(C99-AVGC250)^2 +(C100-AVGC250)^2 +(C101-AVGC250)^2 +(C102-AVGC250)^2 +(C103-AVGC250)^2 +(C104-AVGC250)^2 +(C105-AVGC250)^2 +(C106-AVGC250)^2 +(C107-AVGC250)^2 +(C108-AVGC250)^2 +(C109-AVGC250)^2 +(C110-AVGC250)^2 +(C111-AVGC250)^2 +(C112-AVGC250)^2 +(C113-AVGC250)^2 +(C114-AVGC250)^2 +(C115-AVGC250)^2 +(C116-AVGC250)^2 +(C117-AVGC250)^2 +(C118-AVGC250)^2 +(C119-AVGC250)^2 +(C120-AVGC250)^2 +(C121-AVGC250)^2 +(C122-AVGC250)^2 +(C123-AVGC250)^2 +(C124-AVGC250)^2 +(C125-AVGC250)^2 +(C126-AVGC250)^2 +(C127-AVGC250)^2 +(C128-AVGC250)^2 +(C129-AVGC250)^2 +(C130-AVGC250)^2 +(C131-AVGC250)^2 +(C132-AVGC250)^2 +(C133-AVGC250)^2 +(C134-AVGC250)^2 +(C135-AVGC250)^2 +(C136-AVGC250)^2 +(C137-AVGC250)^2 +(C138-AVGC250)^2 +(C139-AVGC250)^2 +(C140-AVGC250)^2 +(C141-AVGC250)^2 +(C142-AVGC250)^2 +(C143-AVGC250)^2 +(C144-AVGC250)^2 +(C145-AVGC250)^2 +(C146-AVGC250)^2 +(C147-AVGC250)^2 +(C148-AVGC250)^2 +(C149-AVGC250)^2 +(C150-AVGC250)^2 +(C151-AVGC250)^2 +(C152-AVGC250)^2 +(C153-AVGC250)^2 +(C154-AVGC250)^2 +(C155-AVGC250)^2 +(C156-AVGC250)^2 +(C157-AVGC250)^2 +(C158-AVGC250)^2 +(C159-AVGC250)^2 +(C160-AVGC250)^2 +(C161-AVGC250)^2 +(C162-AVGC250)^2 +(C163-AVGC250)^2 +(C164-AVGC250)^2 +(C165-AVGC250)^2 +(C166-AVGC250)^2 +(C167-AVGC250)^2 +(C168-AVGC250)^2 +(C169-AVGC250)^2 +(C170-AVGC250)^2 +(C171-AVGC250)^2 +(C172-AVGC250)^2 +(C173-AVGC250)^2 +(C174-AVGC250)^2 +(C175-AVGC250)^2 +(C176-AVGC250)^2 +(C177-AVGC250)^2 +(C178-AVGC250)^2 +(C179-AVGC250)^2 +(C180-AVGC250)^2 +(C181-AVGC250)^2 +(C182-AVGC250)^2 +(C183-AVGC250)^2 +(C184-AVGC250)^2 +(C185-AVGC250)^2 +(C186-AVGC250)^2 +(C187-AVGC250)^2 +(C188-AVGC250)^2 +(C189-AVGC250)^2 +(C190-AVGC250)^2 +(C191-AVGC250)^2 +(C192-AVGC250)^2 +(C193-AVGC250)^2 +(C194-AVGC250)^2 +(C195-AVGC250)^2 +(C196-AVGC250)^2 +(C197-AVGC250)^2 +(C198-AVGC250)^2 +(C199-AVGC250)^2 +(C200-AVGC250)^2 +(C201-AVGC250)^2 +(C202-AVGC250)^2 +(C203-AVGC250)^2 +(C204-AVGC250)^2 +(C205-AVGC250)^2 +(C206-AVGC250)^2 +(C207-AVGC250)^2 +(C208-AVGC250)^2 +(C209-AVGC250)^2 +(C210-AVGC250)^2 +(C211-AVGC250)^2 +(C212-AVGC250)^2 +(C213-AVGC250)^2 +(C214-AVGC250)^2 +(C215-AVGC250)^2 +(C216-AVGC250)^2 +(C217-AVGC250)^2 +(C218-AVGC250)^2 +(C219-AVGC250)^2 +(C220-AVGC250)^2 +(C221-AVGC250)^2 +(C222-AVGC250)^2 +(C223-AVGC250)^2 +(C224-AVGC250)^2 +(C225-AVGC250)^2 +(C226-AVGC250)^2 +(C227-AVGC250)^2 +(C228-AVGC250)^2 +(C229-AVGC250)^2 +(C230-AVGC250)^2 +(C231-AVGC250)^2 +(C232-AVGC250)^2 +(C233-AVGC250)^2 +(C234-AVGC250)^2 +(C235-AVGC250)^2 +(C236-AVGC250)^2 +(C237-AVGC250)^2 +(C238-AVGC250)^2 +(C239-AVGC250)^2 +(C240-AVGC250)^2 +(C241-AVGC250)^2 +(C242-AVGC250)^2 +(C243-AVGC250)^2 +(C244-AVGC250)^2 +(C245-AVGC250)^2 +(C246-AVGC250)^2 +(C247-AVGC250)^2 +(C248-AVGC250)^2 +(C249-AVGC250)^2)/249) You may also be interested in the following video and forum topic: How to create a Personal Criteria Forumula (PCF) Modelling Bollinger Bands (& Standard Deviation) in a TC PCF -Bruce Personal Criteria Formulas TC2000 Support Articles
Back to top
bobjerritts		Posted : Tuesday, March 5, 2013 3:14:12 PM
Registered User Joined: 3/11/2005 Posts: 16		thanks   works great
Back to top
Bruce_L		Posted : Tuesday, March 5, 2013 3:14:58 PM
Worden Trainer Joined: 10/7/2004 Posts: 65,138		You're welcome. -Bruce Personal Criteria Formulas TC2000 Support Articles
Back to top
Users browsing this topic
Guest-1

Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos

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.