Find Jobs
Hire Freelancers

Excel Spreadsheet for Day Trader

$30-250 USD

In Progress
Posted over 13 years ago

$30-250 USD

Paid on delivery
I need a spreadsheet developed using Excel 2007 for an equities day trader (as in the U.S. stock market). At the end of the day the trader will have a file including all of the executions (trades) they made for the day. There needs to be any easy way to input that data into excel and then have the spreadsheet (that the freelancer designs) display the important data in a format that is practical for the trader. This shouldn't be a very time consuming spreadsheet to create. It's pretty simple. Here is the information required in the spreadsheet: -Ticker Symbol (will come from daily data log) -Type of Trade (will be entered manually by trader) -Date and Time of First Entry (will come from daily data log) -Date and Time of Last Exit (will come from daily data log) -Initial Expected Risk on the Play (will be entered manually by trader) -Actual Risk on the Play (will be entered manually by trader) -Long/Short (will come from daily data log) -# of Shares (will come from daily data log) -Average Entry Price (will come from daily data log) -Average Exit Price (will come from daily data log) -Gross P&L in dollars (calculated in spreadsheet) -Net P&L in dollars (calculated in spreadsheet) -Gross P&L as % of Initial Risk Expected Risk (calculated in spreadsheet) There will be a daily data file with the trades that the trader made for that day. This information will need to be tracked every day of the month. Ideally there will be an indivual place for each day and then a summary of the data for the entire month. There should also be a cover page or something like a cover page with one-click access to any day from the month. For more clarification on what I am looking for, please refer to this webpage: [login to view URL] This project needs to be started immediately. Please do not bid unless you can begin right away. This shouldn't take that much time.
Project ID: 897533

About the project

9 proposals
Remote project
Active 13 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
Please check PMB for details.
$200 USD in 1 day
5.0 (19 reviews)
4.7
4.7
9 freelancers are bidding on average $113 USD for this job
User Avatar
Please see PMB
$175 USD in 1 day
5.0 (84 reviews)
5.5
5.5
User Avatar
REady to work !!!
$120 USD in 3 days
5.0 (10 reviews)
4.4
4.4
User Avatar
Hi, Please check PMB Regards
$150 USD in 1 day
5.0 (6 reviews)
3.6
3.6
User Avatar
Hi, I am interested in this project
$100 USD in 2 days
5.0 (7 reviews)
3.3
3.3
User Avatar
hai We are ready to create the excel spreadsheet and we are the employees of Dell Systems,we give the 100% results
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please check PM for more details. Thank You.
$130 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Please see your PM
$40 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to do the job you are demanding. I am able to do it because I have experience performing various tables on excel working in auditing financial statements and administrative work in a multinational company. In these jobs I had to use different types of formulas (such as sum, average, conditional SI, lookupv, concatenate) and tools (such as sort, filter, subtotal). Therefore, I had to be very accurate in data entry. In order to do my work, I have the MS Office software for Mac 2011. Thank you for reading my bid.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
New York, United States
5.0
39
Payment method verified
Member since Dec 29, 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.