| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/14/2004
Posts: 44
|
I posted a questiom yesterday about the use of precent true formulas use in the backscanner part of snapsheets. I'm not sure that it ever got to 'ask a trainer'. Can they be used to find the buy/sell points that would corraspond to the % true formulas? Do they need to be coverted to Vb.Net? What would they be in VB.Net?
Examples of % true formulas
Long entry; AVGC3 >= AVG(AVGC3,3) AND AVGC3 < AVG(AVGC3,6)
Long exit; AVGC3 <= AVG(AVGC3,3) AND AVGC3 > AVG(AVGC3,6)
Short entry; AVGC3 <= AVG(AVGC3,3) AND AVGC3 > AVG(AVGC3,6)
Short exit; AVGC3 >= AVG(AVGC3,3) AND AVGC3 < AVG(AVGC3,6)
Long entry; AVG(STOC5.3,3) < 30 AND AVG(STOC5.3,3) >=AVG(STOC5.3.1,3)
Long exit; AVG(STOC5.3,3) > 80 AND AVG(STOC5.3,3) <=AVG(STOC5.3.1,3)
Thanks in advance
Bobby Jones /Hottrader
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (hottrader2) Can they be used to find the buy/sell points that would corraspond to the % true formulas?
The formulas themselves cannot be used, but it is fairly easy to create BackScan Conditions that correspond to these formulas.
The first two can be built using the MA vs MA of MA BackScan Condition in the attached SnapSheet in the following topic:
conditions for backscaner/update to first post earlier today
While the BackScan Condition could be saved from this SnapSheet, I've attached a copy of the BackScan Condition itself to this post. Download the attached .scond files to:
\My Documents\Blocks Files\Tool Parts\BackScan Conditions
Once downloaded, you should be able to select Add Condition | My Computer when adding a BackScan Condition to access it.
QUOTE (hottrader2) Long entry; AVGC3 >= AVG(AVGC3,3) AND AVGC3 < AVG(AVGC3,6)
Long exit; AVGC3 <= AVG(AVGC3,3) AND AVGC3 > AVG(AVGC3,6)
Install the MA vs MA of MA BackScan Condition (if you have not already done so).
Select Add Condition (by Buy) | Add Condition | My Computer | MA vs MA of MA.scond.
- Short Period: 3
- Short Avg Type: Simple
- Short MA is: Above or Equal
- Long Avg: 3
- Long Avg Type: Simple
- Bar Time Frame: 1 Day
- # Bars True: 1
- # Bars to Test: 1
Select Add Condition (by first Buy Condition) | Add And Condition | Open... | My Computer | MA vs MA of MA.scond.
- Short Period: 3
- Short Avg Type: Simple
- Short MA is: Below
- Long Avg: 6
- Long Avg Type: Simple
- Bar Time Frame: 1 Day
- # Bars True: 1
- # Bars to Test: 1
Select Add Condition (by Sell) | Add Condition | My Computer | MA vs MA of MA.scond.
- Short Period: 3
- Short Avg Type: Simple
- Short MA is: Below or Equal
- Long Avg: 3
- Long Avg Type: Simple
- Bar Time Frame: 1 Day
- # Bars True: 1
- # Bars to Test: 1
Select Add Condition (by first Sell Condition) | Add And Condition | Open... | My Computer | MA vs MA of MA.scond.
- Short Period: 3
- Short Avg Type: Simple
- Short MA is: Above
- Long Avg: 6
- Long Avg Type: Simple
- Bar Time Frame: 1 Day
- # Bars True: 1
- # Bars to Test: 1
QUOTE (hottrader2) Short entry; AVGC3 <= AVG(AVGC3,3) AND AVGC3 > AVG(AVGC3,6)
Short exit; AVGC3 >= AVG(AVGC3,3) AND AVGC3 < AVG(AVGC3,6)
Install the MA vs MA of MA BackScan Condition (if you have not already done so).
Select Add Condition (by Sell Short) | Add Condition | My Computer | MA vs MA of MA.scond.
- Short Period: 3
- Short Avg Type: Simple
- Short MA is: Below or Equal
- Long Avg: 3
- Long Avg Type: Simple
- Bar Time Frame: 1 Day
- # Bars True: 1
- # Bars to Test: 1
Select Add Condition (by first Sell Short Condition) | Add And Condition | Open... | My Computer | MA vs MA of MA.scond.
- Short Period: 3
- Short Avg Type: Simple
- Short MA is: Above
- Long Avg: 6
- Long Avg Type: Simple
- Bar Time Frame: 1 Day
- # Bars True: 1
- # Bars to Test: 1
Select Add Condition (by Cover Short) | Add Condition | My Computer | MA vs MA of MA.scond.
- Short Period: 3
- Short Avg Type: Simple
- Short MA is: Above or Equal
- Long Avg: 3
- Long Avg Type: Simple
- Bar Time Frame: 1 Day
- # Bars True: 1
- # Bars to Test: 1
Select Add Condition (by first Cover Short Condition) | Add And Condition | Open... | My Computer | MA vs MA of MA.scond.
- Short Period: 3
- Short Avg Type: Simple
- Short MA is: Below
- Long Avg: 6
- Long Avg Type: Simple
- Bar Time Frame: 1 Day
- # Bars True: 1
- # Bars to Test: 1
QUOTE (hottrader2) Long entry; AVG(STOC5.3,3) < 30 AND AVG(STOC5.3,3) >=AVG(STOC5.3.1,3)
Long exit; AVG(STOC5.3,3) > 80 AND AVG(STOC5.3,3) <=AVG(STOC5.3.1,3)
Install the Full Stochastic and Stochastic vs Stochastic BackScan Conditions (if you have not already done so).
Select Add Condition (by Buy) | Add Condition | My Computer | Full Stochastic.scond.
- Period: 5
- %K Period: 3
- %K Avg Type: Simple
- %D Period: 3
- %D Avg Type: Simple
- Stochastic %D is: Less Than
- Value: 30.0000
- Time Frame: 1 Day
- # Bars True: 1
- Bars to Test: 1
Select Add Condition (by first Buy Condition) | Add And Condition | Open... | My Computer | Stochastic vs Stochastic.scond.
- Period: 5
- %K Period: 3
- %K Avg Type: Simple
- %D Period: 3
- %D Avg Type: Simple
- Stoch %D is: Above or Equal
- %D Bars Ago: 1
- Time Frame: 1 Day
- # Bars True: 1
- Bars to Test: 1
Select Add Condition (by Sell) | Add Condition | My Computer | Full Stochastic.scond.
- Period: 5
- %K Period: 3
- %K Avg Type: Simple
- %D Period: 3
- %D Avg Type: Simple
- Stochastic %D is: Greater Than
- Value: 80.0000
- Time Frame: 1 Day
- # Bars True: 1
- Bars to Test: 1
Select Add Condition (by first Sell Condition) | Add And Condition | Open... | My Computer | Stochastic vs Stochastic.scond.
- Period: 5
- %K Period: 3
- %K Avg Type: Simple
- %D Period: 3
- %D Avg Type: Simple
- Stoch %D is: Below or Equal
- %D Bars Ago: 1
- Time Frame: 1 Day
- # Bars True: 1
- Bars to Test: 1Attachments:
MA vs MA of MA.scond - 5 KB, downloaded 581 time(s).
Full Stochastic.scond - 5 KB, downloaded 540 time(s).
Stochastic vs Stochastic.scond - 5 KB, downloaded 585 time(s).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/14/2004
Posts: 44
|
Bruse, I've read your reply to my question and I'm not sure I fully understand your reply. I saved all 3 files to the desk top. One of these files is a duplicate of a file that you sent to me in mid December. This file will open up in snapsheets from desktop without any problems. The problem that I have with
the results of the back test is that it appears to miss some of the conditions and add buy/sell in places where the condition is not there. These comments are based on visual inspection of the back scan chart. I have no idea why this happens. The conditions are stated properly and should find all the points that meet the conditions and should not produce additional points that are not there on the chart. The reason that I sent in the % true question was because of the above problems. The % true formulas corectly find the trade points that I'm looking for. Can you install the file on your computer and do backcans on Nasdaq 100 stocks. Then bo a visual inspection of the 3ma of price in the top pane. I belive that you will find conditions on the chart that meet the conditions of the backcan, but no buy/sell arrows shown on
the price chart. I foung the reverse problem also(buy/sell arrows that did not fit the backscan conditions.
Now the 2 other files that you sent. When you click these files
you get a download dialog box with 2 choices 'opem or save'. I saved to the desktop. When you choice open ,it wonts a program
choice to open the file with. snapsheets? blocks? IF you open with notepad the file appears to conputer code. I'm not sure
what to do with these files. I assume that they need to end up in snapsheets.
Any futher help would be great
Thanks Bobby Jones
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
hottrader2,
Have you confirmed that the MA you're using in the scan is the same MA you have plotted on the chart? Make sure both are using the same averaging type: simple, exponential or front weighted. We've found this to be a common cause of discrepancies between scan results and what you see visually on the chart.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (hottrader2) I saved all 3 files to the desk top. One of these files is a duplicate of a file that you sent to me in mid December. This file will open up in snapsheets from desktop without any problems.
None of the files attached to the above should open up SnapSheets. I suspect you are opening the SnapSheet (.ssh) file from the previous topic.
QUOTE (hottrader2) Now the 2 other files that you sent. When you click these files you get a download dialog box with 2 choices 'opem or save'. I saved to the desktop. When you choice open ,it wonts a program choice to open the file with. snapsheets? blocks? IF you open with notepad the file appears to conputer code. I'm not sure what to do with these files. I assume that they need to end up in snapsheets.
They need to be saved to:
My Documents\My SnapSheets\Tool Parts\BackScan Conditions
As instructed. If you save them to the desktop, you will need to copy or move them to the proper folder.
QUOTE (hottrader2) The % true formulas corectly find the trade points that I'm looking for. Can you install the file on your computer and do backcans on Nasdaq 100 stocks. Then bo a visual inspection of the 3ma of price in the top pane. I belive that you will find conditions on the chart that meet the conditions of the backcan, but no buy/sell arrows shown on the price chart. I foung the reverse problem also(buy/sell arrows that did not fit the backscan conditions.
Start by reviewing StockGuy's answer.
I have done as you asked. The Buy/Sell arrows on my SnapSheets chart match the Custom Percent True Indicators in TeleChart and the visual Moving Average crossovers on the Price Pane. Some things to consider:
A BackScan Buy will occur the period following the period where the BackScan Buy Condition was met.
Another BackScan Buy cannot occur if you are already in the trade as the result of a previous BackScan Buy signal.
A BackScan Sell will occur the period following the period where the BackScan Sell Condition was met.
A BackScan Sell cannot occur unless you are already in the trade as the result of a previous BackScan Buy signal.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/14/2004
Posts: 44
|
Bruce, I did not intend to imply that you had not tryied to do what I had ask you to ess in my question. This set of conditions when applied to buys, sells/go short, cover short/go long should trade every crossover that meets the conditions of the backcan. It will keep you in the stock long or short 100% of the time. I understand that the averare trader would not trade in this manner. I am simply trying to test how well a particual set of conditions tract the market up and down and how profitable it would be if someone chose to
to trade this way. The way that the backcanner is setup (trades
the next day's open)is not my 1st choice of when to trade a signal. Ny choice is to trade the close of the signal day.
You would be shocked at the difference that trading today's close vs tomorrow's open will make in your win/loss % and your ann % profit increase. Maybe backcanner will give use a choice in the near futhure. I have used metastock to backtest trading ideas since 2002. I would like to be able to duplicate what I do in Metastock with Snapsheets backscanner. Set my conditions up in Backcanner to stay in the market 100% of time and see if finds all of the conditions points on the MA price chart. I have seen omissions/missed conditions or extra buy/sell arrows
with no condition present.
Thanks again
Hottrader
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (hottrader2) The way that the backcanner is setup (trades the next day's open)is not my 1st choice of when to trade a signal. Ny choice is to trade the close of the signal day.
The best thing to do would be to submit this suggestion in the Comments/Suggestions Forum.
QUOTE (hottrader2) Set my conditions up in Backcanner to stay in the market 100% of time and see if finds all of the conditions points on the MA price chart. I have seen omissions/missed conditions or extra buy/sell arrows with no condition present.
I'm not sure why this is happening for you.
I have set up BackScanner with the first two of the three setups so the Buy Conditions are the same as the Cover Short Conditions and the Sell Conditions are the same as the Sell Short Conditions. It stays in the trade all of the time.
I also set up a Custom Indicator incorporating both Custom Percent True formulas to make it easier to see when the Buy Conditions as indicated by TeleChart are all in a row and should be ignored (because the trade is already Long) and when the Sell Conditions as indicated by TeleChart are all in a row and should be ignored (because the trade is already Short).
Select Chart Template | Add Indicator | Indicator.
- Visible: Checked
- Center Zero Line: Checked
- Plot using price scale: Unchecked
- Smoothing Average: 1
- Average Type: Doesn't matter (because the Smoothing Average is 1).
- Indicator Formula: (AVGC3 <= AVG(AVGC3,3) AND AVGC3 > AVG(AVGC3,6)) - (AVGC3 >= AVG(AVGC3,3) AND AVGC3 < AVG(AVGC3,6))
You may wish to review the following:
Plotting Custom Indicators with Examples
I then zoomed the charts so they had exactly the same number of bars and sized the charts so they were exactly the same size.
I then scrolled through hundreds of symbols. In not a single case was there a disagreement between TeleChart and SnapSheets.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |