Topic: Trading System Conversion: Excel to FSD. Part One (Warning Long Post)
Part One:
Hello!
I'm new to the forum. I already have a trading system developed in Excel. I'd like to expand the system to include intra-day day trading. Right now, my system makes one (1) trade per day at 0000 GMT. I can be far more profitable, if I were able to auto-execute multiple-intra-day trades on each signal given through my system.
My current Excel based system produces dozens of primary signals that are then filtered (ranked & sorted) and used for the Primary (Master) Trade Signal for the day. Before I even think about switching to FSD, it is very important that I know just how much of my Excel based system is replicable in FSD . In order to understand this, I will need some answers to some basic questions:
1) How do I work with raw data in FSD?
This is a HUGE (MASSIVE) question, because it resides at the heart of whether or not I will have the level of flexibility that I need for system translation (replication) into FSD.
Here is a small example of the structure and modeling practice, I use in Excel to produce a trading system:
I use multiple Excel sheets. Each sheet in Excel represents a component of the system. Three (3) sheets are used for the Real Time Database. Three (3) sheets are used for the Signal Engines. One (1) sheet is used for Metadata. One (1) sheet is used for the Trading GUI. The GUI sheet is Read-Only and I manually enter positions each day at 0000 GMT. In order to help me determine whether or not I can use FSD, you need to know how I generate Trade Signals. Without knowing how I do that in Excel, it is impossible to tell me whether or not I can use FSD.
How do I generate Trade Signals in Excel:
In my current Excel based system, I can Link from any Engine to any price point (OHLC) within any bar of data inside the Real Time Database, either to Daily, Weekly or Monthly data. That is VERY important to know, because it gives me the flexibility to use data from multiple time-frames inside of any Signal Engine (Daily, Weekly or Monthly) and inside of any formula (function) that produces a system Indicator inside of any Engine.
To improve upon my current system, I need to be able to freely access bars of data from any time-frame (1 Minute, 5 Minute, 15 Minute, 30 Minute, 1 Hour, 4 Hour, 1 Day, 1 Week and 1 Month), such that I can REPLICATE any Indicator or any Signal, regardless of which time-frame (bar of data) that it comes from. I do not have the ability to reach below the Daily bar of data (time-frame) with Excel, due to DDE topic limitations that come from MT4 (the provider does not maintain DDE topic lower than the Daily bar).
Before you offer me help, understanding the above is critically important, before you read further. Thank you for your help!
Part One End: