How to open/edit OHLC data in .WL files in 6.0
Author: tedclimo
Creation Date: 11/8/2010 1:45 PM
profile picture

tedclimo

#1
I want to edit lows on symbols that had momentary spikes that show up as legitimate dip trades, but in fact were never humanly tradeable. I want to make dip-script simulations more realistic.

I searched Wiki. Also saw a posting from 2006 that WL 4.x had a Data Editor in Data Manager, but have not found similar feature in 6.0.

Can someone share how to open the .WL data files so I can edit occasional lows?

Thanks in advance
profile picture

Cone

#2
Hi Ted, just open the Dialy chart and double click the bar you want to edit. The Bar Data Editor will appear.
profile picture

tedclimo

#3
Perfect!

Thank you Robert
profile picture

tedclimo

#4
Cone & anyone else interested.
Thought you might be interested in the results (after editing lows that were momentary spikes down).
I ran my dip model(signals generated from EOD daily close data) on the Russell 3000 (RP mode to identify all possible trades) going back 12 months.
I then examined the 1min bars on every profitable trade > 3% (~700 trades). Whenever, I found a trade that had triggered an entry on a momentary spike down (1-2mins in duration).... I edited the daily low (based on 1min bar data)to a realistic point where trader could actually have had time to react. Altogether, I found roughly 150 momentary spikes, then daily lows were edited higher to a level that the 1min data suggested a trader could have reacted to & gotten a realistic fill.

Net,net the ave P/L% per trade was 1.97%(one day hold) before the editing of the daily lows and 1.79% per trade after daily lows were raised(momentary spikes removed). Win% & Profit Factor also had miniscule reductions. Scouring thru the 1min data was a long & painstaking task. But provided the answer to a mystery most of us dip traders have long wondered about.
Yes,occasional momentary spikes (that cannot realistically be traded) do inflate Stats.
But, in my case, only by a small amount and not enough for me to alter my model in any way.

Robert & Eugene, thanks for your tireless support. WLP 6.0 is a dream come true.

Ted
profile picture

Cone

#5
Ted, with Auto-Trading why don't you think those "real" spikes can be bought? After all, it only takes 1 tick below, say, a 98% trigger threshold to put a limit order in the market as the price falls through the limit price. It's even likely that the 2 or 3 seconds of delay that it takes to get the order to market, you'll even get filled at a better-than-limit price.

Nonetheless, it's always good to be more conservative when backtesting :)
profile picture

tedclimo

#6
Three reasons I cannot use Auto-Trading at this time (although I hope it becomes practical for me one day):
1) I trade 3 separate accounts and it's easier to manually place 1 Block trade thru Advisor Channel than Auto-Trade 3 separate accounts (Quote tool tracking 9000 Limit orders(3 accts) instead the 3000(1 block acct) I do now).
2) I never trade Earnings Releases(2 days before nor one day after), so I always validate this fact before allowing a trade to take place. This will be resolved in the next Community.Components update (which includes EPS dates updating more frequently).
3) I never trade stocks that open < 5% above entry limit level. Requiring me to manually validate this & avoid auto-trading. This will also be resolved in an upcoming WLP release that will disallow those trades for me.

Finally, you nailed it. I am extremely conservative in my back-testing. In live trading manually, my experience has been that spike downs lasting < 1min seldom get even partial fills & those lasting 1-2mins end up being tiny partial fills. Perhaps the most significant factor is size of my trades which can be up to 1% of the 10day Ave Daily volume.

All the best,
T!
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).