NexusFi: Find Your Edge


Home Menu

 





Has anyone built a moving average crossover optimization in Excel 2010?


Discussion in Traders Hideout

Updated
    1. trending_up 3,830 views
    2. thumb_up 0 thanks given
    3. group 2 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
buffalotrader100
Simpsonville, SC
 
Posts: 2 since Oct 2013
Thanks Given: 0
Thanks Received: 0

I am not certain where to post this, so I will simply ask the question, and if I am asked to move the post I will.

I am a very experienced trading model builder and trader. I have never really found a good program platform that will allow me to accurately trade equity curve moving averages (and I have tried Market System Analyzer, which is good, but does not always work properly). I have wanted to use an Excel Spreadsheet to 1) perform moving averages (which is simple) but 2) to use iterative calculations with two simple moving average for a crossover screen for an equity curve so that I can maximize profits based on back-testing. I was wondering if any one had used such a thing and could enlighten me as to how I might build a spreadsheet so I could do that. I already have a module that will perform the trades with MA crossover. I just want to be able to do a rather quick optimization without depending on another piece of software. Has anyone ever done this? If so, could you demonstrate how that would work in Excel?


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Irans Dual Probability: Guns Quiet at 99.95% While Forma …
Prediction Markets & Event Contracts
Warsh Drops Easing Bias, December Hike Now Above 50% -- …
Prediction Markets & Event Contracts
ATFX Suspends Prop Trading Unit ATFunded -- Full Review …
Funded Trading Evaluation Firms
The Backwardation Signal: How the CL Futures Curve Tells …
Commodities
Netherlands & Germany Surge as World Cup Field Narro …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
15 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
1 thanks
30 Sessions
1 thanks
  #3 (permalink)
brownbear59
Charlotte
 
Posts: 1 since Feb 2014
Thanks Given: 0
Thanks Received: 0


did you ever find a tool or software for optimizing moving average crossovers in excel?


Reply With Quote




Last Updated on February 12, 2014


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts