
Closed
Posted
Paid on delivery
Excel Stock Trading Log with calculates for each entry line of buy / sell price, +/- percentages of each entry and last line column of running account balance. Line / Column as follows: A-1 Date | B-1 Time | C-1 Buy Qty | D-1 Buy Price | E-1 Symbol | F-1 Sell Date | G-1 Time | H-1 Sell Qty | I-1 Sell Price | J-1 Gross $ | K-1 Cost | L-1 Net | M-1 +/- % | N-1 Acct Balance.
Project ID: 40364309
30 proposals
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
30 freelancers are bidding on average $21 USD for this job

Hi, I am a skilled Excel professional from Vietnam with 25+ years of experience. I can help you develop advanced formulas and calculations for your trading logs. I am currently available and ready to commence work immediately. How can I help you with your Excel task? Best regards, Duong
$30 USD in 3 days
9.6
9.6

As an experienced data analyst and proficient user of MS Excel, I am confident I can deliver exactly what you're looking for with your Excel Stock Trading Log project. My skills and experience in data entry, processing, and analysis make me the perfect fit to create a detailed log template with the required calculations - from buy/sell price percentages, running account balance to +/- percentages. One of my specialty areas is creating organized and efficient spreadsheet templates that simplify complex financial calculations. This combined with my background in data mining will not only ensure accuracy but also provide insights into your trading strategy. I've also had ample exposure to E-commerce platforms like Shopify and Woocommerce, so synthesizing your stock trading data and monitoring your account balance will be handled with ease. My commitment to delivering a quality product on time is unwavering. Let me leverage my extensive knowledge in Excel, empower your trading decision-making process by handling this project for you.
$29 USD in 1 day
7.7
7.7

Hello, I am an advanced Excel specialist who will build a stock trading log with your exact column structure: Date, Time, Buy Qty, Buy Price, Symbol, Sell Date, Time, Sell Qty, Sell Price, Gross $, Cost, Net, +/- %, and Acct Balance. I will include formulas to automatically calculate Gross $ (Sell Qty × Sell Price), Cost (Buy Qty × Buy Price), Net (Gross – Cost), +/- % (Net / Cost), and a running account balance that updates with each row. I will also ensure data validation for consistency. I can deliver within 24 hours. I am ready to start immediately. Regards, Zafar
$30 USD in 1 day
6.3
6.3

Hi there, I will build your Excel Stock Trading Log with precise, fully automated calculations for Columns A-N. My Approach: Dynamic Setup: Format as an Excel Table so formulas auto-fill when new trades are added. Formulas: Gross $ (J): =H2*I2 Cost (K): =C2*D2 Net (L): =J2-K2 +/- % (M): =L2/K2 Acct Bal (N): =IF(L2="","",N1+L2) (Keeps future rows blank until a trade is closed). UI: Freeze headers and add Green/Red Conditional Formatting for Net & %. Experience: I specialize in financial modeling and build trading journals regularly. I ensure 100% accuracy. Ready to deliver this within hours. Let's talk!
$20 USD in 7 days
5.4
5.4

With 12+ years of experience under my belt, I craft bespoke and effective solutions rapidly across web and mobile applications - which includes expertise in Excel automation. In creating your stock trading log, I'd leverage this wealth of experience to build a clean, functional solution that aligns precisely with your needs. My proficiency in Python, PHP, and Laravel is specifically advantageous for this project
$20 USD in 2 days
3.9
3.9

With the extensive experience spanning over two decades, I am more than qualified for this task. I have honed my skills in data entry and management to ?? ???? ??????? partner for this project. Detail-oriented and thorough, I will meticulously organize your trading log, ensuring each input is correctly calculated, and that the mappings are laid out as per your provided format. Moreover, with LinkedIn as one of my core skills, I will diligently research and input the relevant information about each company's symbol, allowing you to get a comprehensive overview of your trades at a glance. This blend of technical expertise and an analytical mindset will be instrumental in producing an efficient system that tracks all buy/sell movements along with their respective costs. Additionally, my accessibility 24/7 means you have the option to check in or suggest changes at any time you like. The flexibility ensures both our productivity and comfort levels. Thank you for considering me for this project; I look forward to working together to create an all-encompassing Trading Log that suits your needs perfectly!
$20 USD in 60 days
3.4
3.4

hello my work is very serious and dynamic, I am punctual and fast I can very well help you in this job I have a lot of experience in the data entry Excel Stock and i am accountant since 15 years, I would like work with you thank you.
$20 USD in 7 days
2.2
2.2

Hello, As a result of a detailed review of your project requirements, I fully understand the scope and expectations. I can build a clean Excel trading log with automated calculations for each row, including profit/loss, percentage change, and a running account balance that updates dynamically. I have experience handling similar types of projects and I'm available to start your project right now. My approach would be to structure formulas for Gross, Cost, Net, and % per trade, and implement a running balance column that carries forward correctly while handling partial sells and edge cases. I bring deep expertise in Excel, Data Processing, Data Analysis with over 10 years of experience. I have a couple of quick questions. • Should the account balance start from a fixed initial value or be entered manually? • Do you need this as a simple sheet or with additional validation and formatting (e.g., highlights for profit/loss)? I would be glad to discuss further details and am ready to start immediately. Looking forward to hearing from you. Best regards, Carlos.
$20 USD in 2 days
1.8
1.8

Hi, I understand your requirement for a stock trading Excel log with accurate buy/sell tracking, profit/loss calculations, percentage analysis, and a running account balance. I can deliver a clean, automated, and reliable sheet with all formulas working perfectly, including handling real trading scenarios. I’m ready to start immediately and ensure quick, accurate delivery. Let’s get this done efficiently. Thanks!
$20 USD in 7 days
0.9
0.9

Tracking trades in Excel with the right columns makes it easier to spot patterns. Your setup with both buy and sell details side by side helps clearly see the lifecycle of each trade. Calculating the +/- percentage based on buy and sell prices right on each line is a smart touch. It gives immediate insight into how well each trade performed without extra steps. Often, people miss updating the running account balance dynamically, which can cause confusion. Making sure it updates with every trade keeps the overall picture accurate and ready to review. I’d structure formulas to flow logically and keep everything automatic, minimizing manual entry errors and streamlining updates. Reach out for a free consultation, happy to share a clear next step with no expectations.
$17 USD in 14 days
0.0
0.0

Hi there I can build a clean, fully automated Excel trading log that calculates everything per entry—profit/loss, percentages, and a running account balance—so you can track performance instantly without manual work. I have strong experience creating advanced Excel sheets with formulas and structured layouts. I’ll set up accurate calculations for gross, cost, net, % change, and dynamic account balance, ensuring each row updates automatically and remains easy to use and extend. The sheet will be well-organized, error-free, and ready for real trading use. You’ll receive a polished Excel file with all formulas in place, clear structure, and smooth performance. Timeline: 1 day Budget: $25 USD
$20 USD in 7 days
0.0
0.0

Hi, I would be more than happy to help you create an accurate Excel trading log according to your needs. I will create the spreadsheet with the same columns as per your instructions and perform the required calculations for gross, cost, net gain/loss, change percentage, and updated balance for every entry. The objective is to maintain the spreadsheet not only precise but also easy to manage by ensuring that no manual changes to formulas are required. Minor improvements such as formatting of profit/loss column can also be added. I am sure that the spreadsheet can be created in a few hours. Please inform me if there is a starting balance or any other formatting options that you have in mind. Best regards, Ehsan
$15 USD in 1 day
0.0
0.0

Hello, With my data entry skills and a sharp eye for detail, I am the perfect fit for creating your Excel Stock Trading Log. Having an Associate’s Degree in Accounting and experience in the automotive industry, I understand the importance of accuracy and organization when dealing with numbers – especially in finance. My skill set includes precisely handling large datasets, processing them quickly yet meticulously. I have advanced proficiency in Excel that specifically covers tracking data, computing percentages, and maintaining running balances accurately as required by your project. I can create formulas and filters that will not only simplify the entry process but also enable you to easily analyze your stock trades for better decision-making. Moreover, my sales background helps me understand the needs and goals of clients on a deeper level. I am committed to delivering results that align perfectly with your vision, saving you time, maximizing efficiency, and ultimately improving your trading performance through this essential tracking tool. Trust me with your project - together we'll raise the bar of your stock trading experience. Best regards, Satria
$15 USD in 7 days
0.0
0.0

Hii ! I'm very excited to work on this project. I have proficiency in excel. Selecting me means not only choosing speed, accuracy, professionalism, and reliability but also an absolute partner in maintaining your assignments fluidity and coherence. I'm ready to start immediately and complete the task within the required timeline. Thanks & Regards Deepak Kumar Jena
$15 USD in 3 days
0.0
0.0

I’m excited to apply for your project. I have strong experience in delivering high-quality work with attention to detail, and I’m confident I can meet your expectations efficiently and professionally. I understand the importance of deadlines, clear communication, and delivering results that truly add value to your business. My approach is simple: understand your exact needs, execute with precision, and ensure you’re fully satisfied before completion. Why choose me? Fast and reliable delivery Clear and friendly communication 100% focus on quality and accuracy Willing to revise until you are satisfied I’m ready to start immediately and can dedicate my full effort to your project. Let’s discuss your requirements in detail so I can provide the best possible outcome. Looking forward to working with you! Best regards, Uditha Pramod
$10 USD in 1 day
0.0
0.0

Hi, I can help you build a clean and accurate Excel stock trading log with all the required calculations and structure. I’ll make sure each entry automatically calculates gross value, cost, net profit/loss, percentage change, and running account balance, so everything updates clearly as you add new trades. I focus on keeping the sheet simple, well-organized, and easy to use, while ensuring all formulas work correctly and consistently. I’m ready to start right away and can deliver a reliable, ready-to-use file quickly. Best regards
$10 USD in 1 day
0.0
0.0

Hi, I am an Excel expert with strong experience in financial trackers. I can build a clean, fully automated Excel sheet exactly as per your column structure: Columns: Date | Time | Buy Qty | Buy Price | Symbol | Sell Date | Sell Time | Sell Qty | Sell Price | Gross $ | Cost | Net | +/- % | Running Account Balance I will add all required formulas for: Buy/Sell calculations +/- percentage for every trade Running account balance (auto-updating on every new row) The sheet will be professional, easy to use, with proper formatting and no errors. I can deliver the complete ready-to-use Excel file within 24 hours after you award the project. I am available right now and can start immediately. Looking forward to working with you.
$22 USD in 7 days
0.0
0.0

Medellín, United States
Member since Apr 8, 2026
$250-750 USD
₹1500-12500 INR
₹600-1500 INR
₹1500-12500 INR
₹37500-75000 INR
$15-25 USD / hour
₹12500-37500 INR
₹600-1500 INR
₹600-1500 INR
₹1500-12500 INR
$10-70 USD
$250-750 USD
₹750-1250 INR / hour
₹12500-37500 INR
₹400-750 INR / hour
$30-250 USD
$750-1500 AUD
$30-250 USD
€5000-10000 EUR
$250-500 USD