I need one prototype plugin: Functionality will be in memory process of several sheets containing price data. We intend to store about 24-27 bytes per daily data bar(day or 15min, 30 min etc) per market. We read them all into memory and then process each days trading just like a real trader and real broker would. Only totals are retained in memory, the rest is output to the results files (trade log, equity log, etc.) and to an excel sheet called trade results and P/L on a realtime basis so there is not storage overhead. Other information is kept in memory as needed (i.e. information about open positions, risk, etc.) so there is minimal storage overhead. Metrics: 100 futures markets 30 years of history per market 260 trading days per year 27 8-byte numbers per trading day per market (Open, High, Low, Close, Vol, OI, MktPos, #contracts, Risk, StrongCorrRisk, WeakCorrRisk, OpenEquity, ClosedEquity, CoreEquity, ReducedCoreEquity, DD, maxDD, volatility, entryrisk, stop_placement1, stop2, stop3, stop4, reserved1-reserved4) 100*30*260*27*8 = 168 Megabytes. The plugin will provide the betsize calculation, buy sell rules, AND it will also provide the money, trade, position management rules. The buy sell rules are already coded as excel vba for several technical studies. Please use the code as the model.(will attach the code after bid accepted). Model of the process flow: excel input (prices up to 99 stocks, 15 futures etc)=> plugin code (process in memory the whole portfolio, or just one)=>excel output as well as log, data files The basic requirements are use the basic (or subset of rules) that I will provide on the portfolio and make buy sell and profit calculations. The plugin must be self loading and should have an icon in excel!!!! I am trying to develop custom studies based on the first prototype so there will be more work if I like the person or persons who take up this bid. Please make recommendations to source language between VB or C
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Well documented, clean code please!!!! 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Excel 97, excel 2000 plugin