I have a number of excel spreadsheets (all in the same format). In each spreadsheet, each row contains end of day historical price data and a numbers from technical indicators
The columns are OPEN, HIGH, LOW, CLOSE, INDICATOR 1, INDICATOR 2, INDICATOR 3,
I would like you to program a VBA macro to run several strategies (probably less than 5 strategies) on the data.
A strategy is a set of rules to enter and exit trades. For example an entry signal might be: IF moving average value (20 days) > moving average value of (100 days) then BUY a stock.
I will provide the rules to you to code for each strategy.
I would also like information shown such as profit/loss on each trade, total profit loss on the account, number of winning/losing trades, % of winning/losing trades, what % of the total capital is lost at any one time (drawdown) etc.
Dear sir
I am an expert in excel and also I am an economist (BA+MBA) by profession, with over 10 years of experiance.
I have vast experience in excel and VBA and i am confident i can assist you with your requirements.
final price and payment terms will be agreed after discussiong the stragegies u wish to see and review of your data.
feel free to contact me over the web site chat for further details
brgds.
Itay
$35 AUD en 3 días
5,0 (3 comentarios)
2,0
2,0
44 freelancers están ofertando un promedio de $78 AUD por este trabajo
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in analysis of stock trading data in Excel and presentation of the results using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project.
Please have a look at some Excel projects I've done:
https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/
https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
Hi,
I have more than 14 years of Excel/VBA exp and I am expert in this kind of work.
Please send me more details so that I can estimate cost and time better.
I have completed more than 290 projects.
Please look at the feedback left by my employers to know more about my work. Waiting for your positive response.
Thanks.
Hi there - My name is Paris.
I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured
if you allow me to serve.
Here is the reason. Why you should pick me?
a) I am a very expert and have the same kind of experience of 5 years.
b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be
done very soon than most of the other providers
c) And most important part is my policy:
"I will give you (to my client) life time support (as long as you keep relation with me).
And fix any bugs/problem without any cost. So, don't ever worry about me”
Please sir, leave a reply ASAP, as I am waiting for your kind reply
hi
I am so interested in your project and I have some experience about the stock market too
start the chat to discuss more ............................................
Greetings!
I have worked on a number of similar projects. I understand what needs to be done.
I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. .
I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you.
Thanks in advance!
Have a Great Day!
Srinivasan Krishnamoorthi
Dear the client,
My name is Hai, I'm an expert in VBA programming and excel templates. I've helped many businesses create their financial, risk management. tatistics models in the insurance, banking, and financial industry.
Now I'm working as a financial analyst for a stock trading company. I'm quite familiar with some trading strategies, some key indicators (technical analysis) in the stock market. (Drawdown, RoMAD, MACD...)
Contact me and I'll give you the best offer
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance
- Built a reservation system
- Built a complex shift allowance calendar and calculator
- Built a complex lookup to sort products into multiple categories
You can see the reviews of the same in my profile
Hi Employer,
I have completed very similar projects in the past.
I have total 6+years of experience with excel VBA macro.
I can complete this work within a day also if I have a clear requirement.
I am ready to start work on it immediately also
Please let me know if interested.
Thanks for the consideration!!!
Hi,
I'm interested in the job.
I'm an Excel expert with rich experiences in Excel VBA programing. I have confident that I can get it done with good quality.
However, regarding to below requirement you have mentioned, could you help provide more details?
----------
I would also like information shown such as profit/loss on each trade, total profit loss on the account, number of winning/losing trades, % of winning/losing trades, what % of the total capital is lost at any one time (drawdown) etc.
Thanks & Best Regards,
Vv
I have many years experience in the financial services sector and have completed similar projects.. Contact me so I can expertly complete this project for you.
Thanks,
Ed
Hello,
The key features that I see in a project like yours would be the professional presentation of the resulting data and the accuracy.
The modules of this application would be divided in INPUT Sheets, PARAM Sheets(containing the parameters of the calculations) and some OUTPUT Sheets containing the output results presented using indicators, graphs or pivot tables.
I just finished a smart VBA tool that was looping trough the excels files from a folder in order to import and process them based on some configurable parameters.
If you like to discuss more about the strategy of your project please contact me.
Best regards,
Marius Avram
I work extensively with Excel VBA at work and I have also done a similar project using Python. If it helps, I also have experience with trading. Mostly options, not much on stocks or forex.
Thinking about this project, I'm suggesting one milestone for the project is to output number of transactions for a few of the strategies and profits only. (This is more of an insurance for us that there is commitment on both ends as I have been screwed over previously)
Hi,
I am professional trader with technology background. I can develop this system for you by adding various other feature that you have asked for like
1) Optimization - You are running your strategy like 20 DMA- now is 20 days optimal? I can provide the code such that you can choose optimal levels for indicators for which strategy yields maximum profit
2) Statistical analysis - You may interested to know if this strategy is alpha generating or not (like a typical hedge fund)
3) Impact of trading costs like brokerage, bid ask spread etc
Thanks,
Anand Sabale