Find Jobs
Hire Freelancers

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.
Project ID: 33745822

About the project

28 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
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
$200 USD in 5 days
5.0 (72 reviews)
6.4
6.4
User Avatar
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
$250 USD in 4 days
4.9 (113 reviews)
6.5
6.5
User Avatar
Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,
$399 USD in 5 days
5.0 (31 reviews)
5.3
5.3
User Avatar
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,
$200 USD in 7 days
5.0 (25 reviews)
4.7
4.7
User Avatar
HI there Myself Yesu I am a VBA/Python developer I can do this can contact me on this for further discussion thanks.
$140 USD in 3 days
4.9 (35 reviews)
4.7
4.7
User Avatar
"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!"
$140 USD in 3 days
4.8 (15 reviews)
4.0
4.0
User Avatar
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
$250 USD in 7 days
4.9 (7 reviews)
3.6
3.6
User Avatar
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
$30 USD in 1 day
4.9 (6 reviews)
2.0
2.0
User Avatar
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
$200 USD in 3 days
5.0 (3 reviews)
1.7
1.7
User Avatar
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
$100 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
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
$80 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$90 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
yes i am hair. my expre one year . i am data entry operator ..............................................................
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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...
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$150 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm professional Excel programmer I like working in Excel it's easy for me i have been working with Excel 7 years
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$40 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Dallas, United States
4.9
11
Payment method verified
Member since Apr 23, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.