Find Jobs
Hire Freelancers

Stock transaction tracking over multiple day(connected to Interactive Brokers TWS API)

$750-1500 USD

Cancelled
Posted over 2 years ago

$750-1500 USD

Paid on delivery
Need a Windows Desktop App, connected to TWS, to track the stock, options & futures buys, and sells from the first buy till the last sell or from the first short sell to the last cover. Buys/Sells can span days/weeks/months. Need to track the Ticker Symbol, Total shares held, average cost, details of each buy/sell (Like time and price), Total profit/loss (Realized + Unrealized), P/L unrealized, P/L realized. Some background: I am a swing trader and buy/sell the same stock multiple times over the course of days/weeks/months. Currently, TWS doesn't display the total profit for the position. Any P/L realized is not shown the next day and also the average cost is based on the current position and new fills and doesn't keep track of the average cost of all the buys/sells. An example Day 1: Buy 2000 shares of ABC at 10/share. The average cost is $10. P/L realized is 0. Total P/L is based on the current price(should be able to get real-time quotes from TWS respecting the pacing violations) and the current average cost. Unrealized is total - unrealized. Day 2 : Sell 500 share at $12/share. Average cost is now 9.33 (((2000*10) - (500*12)/(1500)). Realized is $1000, Total P/L is ((Current price - current average cost(9.33))) * current share held(1500)). Unrealized is total - realized. So let's say the stock falls ot 9.33, total P/L is 0, Realized is 1000, Unrealized is -1000. Day 3: Buy 100 Shares at $11/share. Average cost is now 9.43((9.33 * 1500) + (100*1100)). Realized doesn't change. Total and unrealized P/L based on the Real-time quotes. Day 4: Sell all 1600 at $12. (Total and realized is (12-9.43)*1600). Unrealized is 0. It should remain visible for that day and should move to a historical tab at the start of trading on the next day. When I click on the historical tab, it should display all the buys/sells and should be accessible for a configurable period( I am thing 1 year). When I click on the stock (there should be a + sign before the stock, to indicate that the stock was bought/sold multiple times during the configurable period (definition of configurable period below).), it expands and shows all the buys and sells including date/time and price. All the buys/sells that happen in a configurable period are bunched together and shown as a single entry, with price being the average of all the buys/sells but should again be expandable to further display the details of each individual transaction. The only exception is there has been a closing transaction during that period, then it needs to be separated out. So, if configured the time period to be 5 minutes, and make 4 buys of 100 shares with a price of 9.95, 10.12, 10.05, 9.88, it should be shown as a single buy of 400 shares @ $10 each. However, if I sell some. let's say after 2 buys, then the first 2 buys are shown together, then the sell, and then the next 2 buys, with the ability to drill down further for the individual buys/sells. Also, it should use the WEB API to get the transactions in case the app wasn’t started along with the TWS. Realized P/L calculation should be configurable, Last In First Out or Lowest Cost First. Display lines should alternate between different colors so as tell the two different lines apart or have a thin line between each entry. Everything needs to be configurable, like font type, font size, font color, row colors. Columns size and order of the columns. As well as rows to adjust to the font size. Row order should also be sortable, in reverse order or forward order. Rows order should also be manually changeable. (Each column should have an option to sort the rows 3 ways, low to High, High to Low or back to the customized order if it was customized. Will need well-documented/commented source code as part of the deliverable.
Project ID: 31862603

About the project

11 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
$0 USD in 7 days
4.6 (16 reviews)
3.6
3.6
11 freelancers are bidding on average $1,521 USD for this job
User Avatar
Hi, I am interested in your project and like to handle it. Thank you for the invitation send me a message to discuss the project in details.
$2,555 USD in 30 days
5.0 (6 reviews)
5.8
5.8
User Avatar
Hi, Client! I think I am the developer you are looking for and suitable for this task in concern of your posted project. ****************************************** ###-Because I have 7+ years of rich experience in "Software development", therefore I mastered C/C++/C#, Qt, VBA, Java and Python-### &&&-Besides of that, I also have strong expertise in OpenGL, .NET 5.0/6, Algorithm, Microsoft SQL Server, Windows Desktop, RESTful API and Software Architecture-&&& ****************************************** I've previously worked on the similar projects for another employer. I'm willing to discuss more detailed contents about your project. If you present me chance I will start right now and work full time in your time zone. Besides of that, I guarantee the highest quality, good communication at any time and finishing within deadline. I wish we will keep a good relationship for a long time in the future. Thanks and Regards.
$750 USD in 7 days
4.8 (13 reviews)
5.6
5.6
User Avatar
hello sir , i already built trading plateform where i use Zerodha/Alice blue/Angel/Profitmart api for trading order, buy/sell, square off possition /margin etc feature. we also did automated trading using amibroker csv file. let me know i can show you demo. i am full time freelancer team and have 10 years of experience in 1 web and window development in asp.net c#, javascript,sql server . 2 Android mobile development i can do work as per your requirement . I can quickly understand the details and idea of your project so I think my technology is suitable for your project. Let me know your message.
$1,500 USD in 7 days
5.0 (1 review)
4.6
4.6
User Avatar
Hello, Thanks for sharing your requirement. I am a senior Desktop App developer. I have enough experience in C#, .NET, ASP.NET MVC and Core. So I can implement what you want in a short time. If you hire me for this project, I will guarantee the qualification of my result and I will try hard to satisfy you. Best regards
$750 USD in 7 days
4.6 (1 review)
2.1
2.1
User Avatar
Hi. i have read your requirements and i am fully confident that i can develop this kind of stock transaction tracking system in C# I have expertise in C# with more than 10 year of experience. I can handle any kind of task and assure you that you will get good quality of work. I am interested in working with you on this project and I am willing to proceed further with the discussion. Please send me a message and we can have a quick chat right away. because i have few questions about your query I am waiting for your positive response. Best Regards, Alphatech
$750 USD in 7 days
4.7 (3 reviews)
1.6
1.6
User Avatar
Hello, Having reviewed your project descriptions, I will need more details regarding your project. Rest assured that I am capable of delivering the desired result in your project because what you are looking for is my area of expertise. I am well trained in developing trading bots for crypto-exchange trading platform and trading tools (Indicator and Auto-trader) for trading platforms like ProReal Time, Metatrader, Amibroker, Interactive broker, Pine script, Sierra chart, Ctrader, Thinkorswim Algorithm, Tradestation, and Ninjatrader (NT8 and NT7). Do chat with me now to discuss your project further. Thank you
$1,500 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
SANTA CLARA, United States
0.0
0
Payment method verified
Member since Jun 21, 2011

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.