trading system backtesting in excel -- 2

an existing excel spreadsheet would need to be altered/coded to be able to backtest a stock trading system automatically. The spreadsheet already shows buy and sell signals, quantity, and stop loss levels. What I need is an automated calculation of profit and loss. E.g. if the price on day 1 is 980 and if there was a buy signal on day 0 at a price of 1000, a quantity of 10 and a stop loss at 950 the system should should on day 1 show -200. If the price stays above 950 and no ‘sell’ signal comes up, the calculation goes on each day. If thr price goes below 950 the system should show -500 going foward, until a new trade is entered based on a signal.

The signals and all other inputs are already calculated by the system/spreadsheet, I just need a way to backtest historical price data.

Квалификация: Visual Basic, Обработка данных, Excel, Архитектура ПО, Python

Показать больше trading platform excel export, macro excel copy existing cell data copy, trading indicator excel, excel update existing pivot tables connection, forex trading backtesting, options trading backtesting, backtesting excel trading strategy, trading backtesting, forex backtesting excel, backtesting trading systems excel forex, trading program excel, forex trading software excel, automated trading program excel, backtesting excel, backtesting excel strategy, backtesting trading strategies excel, building trading programs excel, import excel sheet existing access table vb, writing trading program excel, excel historical data trading backtesting

О работодателе:
( 0 отзыв(-а, -ов) ) London, United Kingdom

ID проекта: #21748774



Hi, Sir!! i am a python expert and full-stack developer with full time. -):-):-) i want to help you with my python skills :-):-):-) “””” Specially Data Science , Data Analysis “””” i use sklearn , Tensorflow, k Больше

£135 GBP за 7 дней(-я)
(56 отзывов(-а))

25 фрилансеров(-а) в среднем готовы выполнить эту работу за £159


Hello Sir Im excel VBA macro and formula Expert :) i have background in trading forex also so i think i will more understand what you want Sir please ping me for discuss more and im able to start working today if every Больше

£250 GBP за 7 дней(-я)
(372 отзывов(-а))

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Больше

£135 GBP за 7 дней(-я)
(222 отзывов(-а))

Hi there, Being an expert in Python programming I can do this project for you. please leave a message on my chat so we can discuss the budget and deadline of the project. Also, have a look at my profile for my reviews Больше

£250 GBP за 4 дней(-я)
(24 отзывов(-а))

Hi, I'll try to keep this short i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own scrapers and Больше

£175 GBP за 7 дней(-я)
(26 отзывов(-а))

Hello! I'm Alex, professional programmer for financial markets I'm very familiar with excel integration to different trading platforms and in excel calculations generally. In your case I think is better to make a VBA m Больше

£200 GBP за 5 дней(-я)
(15 отзывов(-а))

Hi there Can i see your mockup or wireframe of this project? [login to view URL] I have rich experience in Python Let me know if you are interested Thanks JIN

£500 GBP за 3 дней(-я)
(14 отзывов(-а))

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time [login to view URL] share comp Больше

£135 GBP за 7 дней(-я)
(21 отзывов(-а))

I'm very happy to bid on your project. I read your description carefully and am very interesting in your project. I can start right now and I can confirm high quality. If you hire me,I will do my best for your job and Больше

£135 GBP за 7 дней(-я)
(4 отзывов(-а))

Hi, Nice to meet you! I have read your requirements carefully and I am very interesting for your project. I am confident of this project as I'm a professional Python expert with over 5 years of experience. It seems to Больше

£135 GBP за 7 дней(-я)
(12 отзывов(-а))

I recently built a trading platform for one of my clients and he was happy to extend it further as he was making profits from the market. Please share your trading sheet so that I can help you get it upgraded. Excel Больше

£250 GBP за 7 дней(-я)
(4 отзывов(-а))

I have read your project and I am expert in this field. I can do this for you within due time and honestly. I also have a few questions to discuss. Kindly contact me and we will discuss time and budget. Thanks

£135 GBP за 7 дней(-я)
(8 отзывов(-а))

Hello There, In short I have done Excel teal time trade testing and programming. I look forward to hear you. Thank you, Sincerely, anuj

£100 GBP за 4 дней(-я)
(5 отзывов(-а))

"I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I am also very good at capturing data from internet and organizing it in a way which becomes very easy to retrie Больше

£100 GBP за 7 дней(-я)
(6 отзывов(-а))

Hello Sir/Madam, Please Message me to discuss in more details. I had done many backtesting projects for Stock market which included screening conditions as well. I Had also completed many projects for Algo Trading an Больше

£220 GBP за 15 дней(-я)
(3 отзывов(-а))

I have read your description carefully and i think i am perfect fir this projec. I have a lot of experience like this projec. I am very interested for your projec. I hope you will hire me. I am waiting for you.

£100 GBP за 7 дней(-я)
(3 отзывов(-а))

Hi I have more than 15 years experience working with XL and doing analysis on data. Question about your task description. Where do the signal and input generated by your system go. Are they output to the same spreads Больше

£100 GBP за 3 дней(-я)
(2 отзывов(-а))

Hi Dear sir/mam. I went through the description of the task and found myself to be a perfect match for it. I am a Certified Excel Specialist. I am willing to accomplish this task. I hope the service provided will meet Больше

£50 GBP за 2 дней(-я)
(1 отзыв)

Hello, I have an MBA from the University of Chicago, and a lot of experience with excel and data analytics. Would be able to back test your data accurately.

£135 GBP за 7 дней(-я)
(0 отзывов(-а))

Please accept my proposal

£150 GBP за 3 дней(-я)
(0 отзывов(-а))

=== 100% SATISFICATION!=== I checked your suggestion in detail and I want to do your project as soon as possible. Because I have excellent in skills that similar your project with more than 7 Years experience. I'm Больше

£200 GBP за 3 дней(-я)
(0 отзывов(-а))