User-programmed - TPABasic™

Use the User-programmed question either:

a) to ask something that is cumbersome to ask using the standard dialog-based interface of TPA

b) to carry out quantitative analyses that cannot be asked at all using the standard interface.

The dialog interface allows you to ask questions that begin "When did..." or "Show me all the days when..." i.e., questions which, when applied to each day, give either "yes" or "no" as an answer. Sometimes, however, you want to ask questions like "By how much, on average, did...", i.e., questions whose answers are a number. While these are not technically questions in the strict sense of TPA, they are nonetheless useful queries.

TPABasic is compatible with Visual Basic for Applications (VBA), and has a wide range of features including OLE automation (so you can control e.g. Word or Excel from within TPA).

To learn more about TPABasic, see also: Setting up a User-programmed - TPABasic™ question

Example:

         The average range of <C> period for all of 1992.

Questions from Traders:

         On average, what is the contribution of the half hour after the first 2 hours of trading to the development of the days range?

Setting Up the Search:

Click on the parts of the box below where appears for explanations of features.

Answers:

         The average range for <C> period in 1992 was 5.96 ticks.