Hey thanks Sharks,I had a feeling you would still be using excel...

First 31 Last

Share
Profile

Follow
TwoHandsRevy

815 Posts.

08/01/19

18:48

Post #: 37060533
Share
Originally posted by sharks37: ↑

Hi TwoHands yes I still use primarily Excel to validate my "trading ideas".

There are a couple of reasons for this:
I have developed a template in Excel that I find handy to use for a range of different ideas. The data comes from Ctrader and I can validate every data point (i.e. trade taken by a model) down to the M1 level going back almost 10 years.
In contrast with the MT4 tester environment I still have an issue with the quality of M1 or tick data going back more than 12 months (hopefully the EA Labs new own internal backtester platform will overcome this but I haven't tested it yet).
The first ideas to progress to demo stage and now live are all pure price action based so they lend themselves to spreadsheet level formulae to perform the calculations required for my ideas.
My experience so far has taught me that there is value in doing the spreadsheet based data validation and quality control (checking every data point on the chart, or at least any data point which may have some ambiguity and so requires checking) - because visualy checking hundreds of data points continues to provide me with insights on price action dynamics that give me a feel for what factors to optimise (if any) or new trade ideas coming from seeing certain patterns repeated often enough.
I think the above will continue to apply while the ideas I am testing remain relatively simple (and perhaps with only the most basic indicators) so I can write templates for them in Excel, or until I become satisfied that the data quality on the MT4 or EA Labs backtester becomes good enough for my quality criteria. While the spreadsheet work is partly automated, it is still laborious and can take several weeks to test an idea fully on a range of markets, so I am incentivised to find a better option, but for now I am happy to do that level of work to get the degree of confidence I am looking for.

Once I have done the spreadsheet work, and then built an EA, running the EA in backtest mode on MT4 and then demo mode is really not to provide me with the backtest statistics, its really just to confirm the various elements of my EA programming execute as designed.

Cheers, Sharks

Expand

Hey thanks Sharks,

I had a feeling you would still be using excel to validate ideas rather than just slapping something together in the code editor.
2 Upvote

Reply

Top Stories

History-making uranium sample grades and an imminent drill run. Infini Resources is poised to transform in 2025

AXP

Tambourah chases gold veins and mineralisation extension with drilling

MIN

MinRes's Ellison knows he screwed up – for that reason, hunt for new Chair to be sped up

ACW

This biotech stock raised $11M in a risk-off environment. Its Alzheimer's drug could change the game

WC8

Pan Asia rebranding to 'clear confusion' after bagging $35M for Chile projects

There are more pages in this discussion • 437 more messages in this thread...

First 31 Last

Hey thanks Sharks,I had a feeling you would still be using excel...

History-making uranium sample grades and an imminent drill run. Infini Resources is poised to transform in 2025

Tambourah chases gold veins and mineralisation extension with drilling

MinRes's Ellison knows he screwed up – for that reason, hunt for new Chair to be sped up

This biotech stock raised $11M in a risk-off environment. Its Alzheimer's drug could change the game

Pan Asia rebranding to 'clear confusion' after bagging $35M for Chile projects

Featured News

Featured News

Hey thanks Sharks,I had a feeling you would still be using excel...

Top Stories

History-making uranium sample grades and an imminent drill run. Infini Resources is poised to transform in 2025

Tambourah chases gold veins and mineralisation extension with drilling

MinRes's Ellison knows he screwed up – for that reason, hunt for new Chair to be sped up

This biotech stock raised $11M in a risk-off environment. Its Alzheimer's drug could change the game

Pan Asia rebranding to 'clear confusion' after bagging $35M for Chile projects

Featured News

Featured News