Stock trading / portfolio management system in Excel
- or -
Post a project like this4812
£1.0k(approx. $1.2k)
- Posted:
- Proposals: 1
- Remote
- #55576
- Awarded
Description
Experience Level: Expert
I have created a clumsy spreadsheet that contains my logic and calculates buy/sells of one stock over time. I need my logic programmed into a custom formula so that I can run it across many stocks at one time with two objectives: 1) to measure the efficiency over time (ie back testing) of each stock and of the portfolio and 2) to generate orders for buying/selling.
After this job is done, I need to update a portfolio of 100 stocks with daily data using eSignal DDE, measure each stock\'s trades over time, generate orders from all 100 stocks, allocate capital from a central portfolio of capital and measure the results of the overall portfolio. Later, a future and subsequent job, I plan to integrate this system into a broker\'s API so that the system can submit orders generated by the my logic.
I must be able to enter into a non-disclosure agreement with you and I must own all the intellectual property including all of the code.
If you have specific experience with financial markets, multiple spreadsheets to house data and central processing of data from these various spreadsheets, it will be an advantage. Open question - can this be done more efficiently by using Access (or another database) in additional or in place of Excel?
After this job is done, I need to update a portfolio of 100 stocks with daily data using eSignal DDE, measure each stock\'s trades over time, generate orders from all 100 stocks, allocate capital from a central portfolio of capital and measure the results of the overall portfolio. Later, a future and subsequent job, I plan to integrate this system into a broker\'s API so that the system can submit orders generated by the my logic.
I must be able to enter into a non-disclosure agreement with you and I must own all the intellectual property including all of the code.
If you have specific experience with financial markets, multiple spreadsheets to house data and central processing of data from these various spreadsheets, it will be an advantage. Open question - can this be done more efficiently by using Access (or another database) in additional or in place of Excel?
Deon J.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
18 May 2011
Australia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies