Write two procedures in VBA for my Excel trading system to process historical data and record trades and results.
$30-250 USD
Completed
Posted almost 2 years ago
$30-250 USD
Paid on delivery
I'm looking for a professional Excel programmer that can incorporate historical market data processing into my own system.
Now my spreadsheet receives market data and trades according to my procedures. I want to be able to take historical tick data and run my rules through historical data to see if it will work instead of waiting weeks for results.
I will provide sample screenshots or even my actual Excel file with what I'm trying to accomplish. The final output folder should show trades taken, prices, contract quantities traded, and P&L of the results. Prefer to have a check box on the screen that will select a live trade or run through the historical data which I will provide.
Basically, I will need you to write two procedures, first to read data from another folder line by line, and based on the prices and my rules code another procedure to execute orders and perform a paper trade with P&L functionality.
Thanks to everyone for your consideration.
I myself is doing Algo trading using Excel VBA and understand the requirement very well. I receive tick data in excel and have a button instead for real time paper trading or live trading. I'm having around 3/4 years of trading experience so can do the job.
$200 USD in 7 days
5.0 (1 review)
2.6
2.6
28 freelancers are bidding on average $173 USD for this job
Hello,
I have recently created an Excel file that pulls real time stock data together with historical data back to 10 years.
The file also has Buy, Sell Low, Sell high suggestions with conditional formatting (the background of the Buy price gets light green when current price is within the range of 3% of the Current Price. the opposite for By Low and Sell high).
Also the Excel sheet scraps a site to get P/B, Dividend & Dividend % from each selected Ticker in the list (the according table has a lot of financial info concerning the company that can be scraped).
Please have a look at my profile to see an image of this excel file and also the current reviews of the client I created this project.
Hope to work for you.
Regards,
Alexandros
Hello!
I'm a Excel and VBA expert more than ten years.
I have completed many complex projects in my practice and I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality!
You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f
Regards,
Vladimir
Hello,
Please provide more details as you wrote. I will then create a short document that summarizes what my macro will do, and if then we are at the same understanding I will continue with programming.
Best Regards,
Serdar Yalcin,
"Dear Client,
I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, tables, absolutely any request will be satisfied.
If necessary, I will write accompanying documentation or video. Ready to solve a problem of any level of complexity.
Services Offered:
✅Automating Tasks.
✅Data Validation.
✅Data Analysis.
✅Custom Formulas.
✅Creating User Forms.
✅Charts.
✅Pivot Tables.
✅Formatting, Fixing, Forms, Formulas, Functions.
✅VBA Macros Automation.
✅Web Scraping/Data Mining from any website and any amount of
data.
✅Data collection, Images Downloadable / Images URL.
At any time ready to provide support on emerging issues. I am happy to provide after-sales support, you can always count on me.
""✌️People like surprises and here I come into play, to present your ideas to the world in the best manner✌️"".
Please don't waste your time looking around. Please feel free to contact me. I'm ready to start your project.
Thanks in advance!"
Hi, I have few years experience in automatic data extraction, analysis, sorting and filling, creating formulas, macros in Excel, Word and developing helpful Visual Basic applications for user's needs.
I can make VBA macro to get historical data from Yahoo Finance and other 2 procedures.
Bets regards,
Remis
Hi I had read your requirement and I can create VBA for trading system. I have 5+ experience in advanced excel, VBA macro. I'm expert in advanced excel, vba macros, complex formulas, dashboards
and I can start your work immediately right now. I will be available for any query round the clock even if the project is completed.
Please award me this project so that we can discuss it more hope will get a chance to work with u .
You can check my Portfolio for your reference.
Thanks & Regards
Hi sir/madam,
I'm very active and interested to work with you.
My time is up to you.
I have many experiences in this case and you could award your project to me and enjoy it.
With best regards
Hey!
I have vast experience in Excel and Excel VBA, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time writing position, and I am happy to work on a freelance basis if that is what you prefer.
I look forward to hearing from you soon! Thank you for your time.
Thanks & regards
- Wilfred
Hello!
I've carefully checked your requirements and really interested in this project. I'm a full-time data and statistical analyst. I have worked with many clients across the world. I have rich experience in Data Entry, Word, Excel, Copy Typing and Data Processing.
Thanks, shah
Hello, Tamer How are you?
I have rich experience with building excel documentsd and implement web froms.
Please send me a message so that we can discuss more.
Thanks.
There are two kinds of people: Those who take the credit and those who actually do the work. If you're looking for the latter, then you're in the right place!
For over 4 years in the Haque Group as a pay roll officer and over 4 years as a computer service holder , the different experiences I had honed my skillsh, helped me acquire new ones and made me develop a strong work ethic. I always make sure that I don't take anything for granted. I always give my clients more than what they expect to get. Delivering excellent service is what I do because I believe that having a good work relationship is the key to success. If you're not taking care of your...
Hello sir
I have gone through your project details. I am interested in this project. please give me a chance to work with you. I have many years experience in this field. Thank you
Hii sir,
I have read your project carefully and Very excited to work with you. Your project matched my skill. I can do the excel sheet project well. Please hire me.
Thanks.
Hello!
I am a new freelancer on Freelancer.com. I have solid profile and track record on Fiverr (another freelance platform which currently does not work in Russia).
I have broad experience in financial modelling, excel and VBA. I will be glad to assist you and complete your task.
Kind regards,
Simon