Excel Spreadsheet for Day Trader
Required skills: Excel
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: http://www.smbtraining.com/blog/evaluating-your-trading-results-part-23
This project needs to be started immediately. Please do not bid unless you can begin right away. This shouldn't take that much time.
Additional information submitted: 12/29/2010 at 17:49 EST:
Also, I will be readily available to help with any questions during the project.
Thanks!
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: http://www.smbtraining.com/blog/evaluating-your-trading-results-part-23
This project needs to be started immediately. Please do not bid unless you can begin right away. This shouldn't take that much time.
Additional information submitted: 12/29/2010 at 17:49 EST:
Also, I will be readily available to help with any questions during the project.
Thanks!
Posted In:Excel |
Related projects:
Excel spreadsheet for stocktaking
Looking for an excel spreadsheet to run in a barcode scan (Motorolla Symbol MC) to count stock in a small shop. Thanks
Excel spreadsheet for stocktacking
Looking for an excel spreadsheet to run in a barcode scan (Motorolla Symbol MC) to count stock in a small shop. Thanks
Install Excel Spreadsheet - Editable Online
I need this sheet to display full screen on my URL.
Only 4 cells should be editable by people who visit the website. The rest of the cells should be locked (uneditable).
For someone who knows how to use Excel formulas, this is literally a 5 minute job. But more importantly, it is a chance to begin a relationship with a new client who will have multiple projects in the future.
Please help. My bid for this 5 minute project is $ 10.
Only 4 cells should be editable by people who visit the website. The rest of the cells should be locked (uneditable).
For someone who knows how to use Excel formulas, this is literally a 5 minute job. But more importantly, it is a chance to begin a relationship with a new client who will have multiple projects in the future.
Please help. My bid for this 5 minute project is $ 10.
Data Capture Copied Into Excel Spreadsheet
I am looking for further data to be copied from a website into an excel spreadsheet.
Looking for exceptional data capture worker.
Ashley
Looking for exceptional data capture worker.
Ashley
Need Quick Excel Spreadsheet. 2
ble4.png" target="extlink" rel="nofollow" style="text-decoration: none;color:#68778E" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">http://tctechcrunch.files.wordpress.com/2010/05/groupontable4.png
Additional Info (Added 10/30/2010 at 10:52 EST)...System Message: This is a reposting of project need quick excel spreadsheet. (1288304097).
Additional Info (Added 10/30/2010 at 10:52 EST)...System Message: This is a reposting of project need quick excel spreadsheet. (1288304097).
Re: Excel Spreadsheet With Formula To Css / Javascript
calculator) - This i need done urgently !
2) Select country and model - will display info based on the excel spreead sheet (2nd sheet)Would appreciate if you could complete this also
3) input some values and it will calculate based on formulas in spreadsheet. (This you have till tomorrow to complete)
Thank you. I need this done tonight or at least the 1st 2 sheets be completed first tonight. Cheapest and fastest bid wins this with excellent ratings for a quick job.
2) Select country and model - will display info based on the excel spreead sheet (2nd sheet)Would appreciate if you could complete this also
3) input some values and it will calculate based on formulas in spreadsheet. (This you have till tomorrow to complete)
Thank you. I need this done tonight or at least the 1st 2 sheets be completed first tonight. Cheapest and fastest bid wins this with excellent ratings for a quick job.
Need products placed in Excel spreadsheet for upload
ample of the spreadsheet but it' 18.1 Mb and wouldn't upload).
I'm appreciative of your considering this post and am open to questions. I will accept bidding for 2 days and will choose someone by Monday so that work can commence. Once you are awarded the job you will need to complete it within 2 days. If these requirements suit your qualifications please place your bids.
Thanks.
I'm appreciative of your considering this post and am open to questions. I will accept bidding for 2 days and will choose someone by Monday so that work can commence. Once you are awarded the job you will need to complete it within 2 days. If these requirements suit your qualifications please place your bids.
Thanks.
Excel spreadsheet for Home Base
st be entered into Excel spreadsheet. the spreadsheet will contain 390 rows with approximately 60 columns wide. Most of the scanned pages are upside down so you still need to rotate the pages. There are different questionnaires so you must be careful and make sure that the answers are being placed in the right column. Some of the questions are in Spanish and some are in English. We prefer to applicant who understand both.
Thanks
Thanks
Convert PDF accounts to Excel Spreadsheet
vel of accuracy and everything must balance at the end of each month.
I can provide an example to the winning bidder of what the excel needs to look like
I am happy to pay a per page price to make it fair because I'm not totally sure how many pages there are currently
The Spreadsheet needs to be organized as one sheet to credits and one sheet for debts.
Thank you for taking the time to look at this project
I can provide an example to the winning bidder of what the excel needs to look like
I am happy to pay a per page price to make it fair because I'm not totally sure how many pages there are currently
The Spreadsheet needs to be organized as one sheet to credits and one sheet for debts.
Thank you for taking the time to look at this project
Copy PDF menus into Excel spreadsheet.
ing:
The product name
The product description
The price
These must be entered with 100% accuracy or I reserve the right not to pay for that menu until it is fixed.
This is ongoing work. I have around 500 or so menus to begin with, but over the next year this will increase to thousands.
Please contact me with any questions.
The product name
The product description
The price
These must be entered with 100% accuracy or I reserve the right not to pay for that menu until it is fixed.
This is ongoing work. I have around 500 or so menus to begin with, but over the next year this will increase to thousands.
Please contact me with any questions.
Word .doc To Excel Spreadsheet
I need someone to transform a word document to an excel spreadsheet.
The form must be formatted to legal size paper 8.5x 14
Must include the shading that increases as text is typed.
The form must be formatted to legal size paper 8.5x 14
Must include the shading that increases as text is typed.
Daily Excel Spreadsheet 30days
an excellent understanding of excel, including HLOOKUP and VLOOKUP formulas. If you do not know what these are, DO NOT BID!
The data is available up to 7 days in advance, so you can do this once or twice a week if you want. English MUST be your first language, and I would prefer someone in the US, but am willing to work with excellent English speakers overseas, as long as you have WAY ABOVE NORMAL EXCELLENT EXCEL experience.
Please quote doing this for 30 days.
The data is available up to 7 days in advance, so you can do this once or twice a week if you want. English MUST be your first language, and I would prefer someone in the US, but am willing to work with excellent English speakers overseas, as long as you have WAY ABOVE NORMAL EXCELLENT EXCEL experience.
Please quote doing this for 30 days.
2nd Person Data Mining/Excel Spreadsheet
rnaround desired!
We are asking for a trial run with an average of less than 100 products to be turned around in 24hours. If the quality and the quantity are satisfactory then we will assign you a new catalog. Size of catalogs may vary.
If everything goes well then we give you more responsibility and more tasks. We are looking for a long-term team player as changes are made regularly to catalogs. Future assignments would most likely be at least monthly.
We are asking for a trial run with an average of less than 100 products to be turned around in 24hours. If the quality and the quantity are satisfactory then we will assign you a new catalog. Size of catalogs may vary.
If everything goes well then we give you more responsibility and more tasks. We are looking for a long-term team player as changes are made regularly to catalogs. Future assignments would most likely be at least monthly.
Need Custom Excel Spreadsheet
>2. Needs to have summary by month on the first page as well (only total profit or loss)
3. On the inner pages, I need to be enter the project title, the estimated final price of the project, all the separate expenses, and all the separate income
4. Each tab should be a different project
5. Projects (tabs) should automatically be in alphabetical order
6. Each time I create a new tab, the default template needs to be there.
I'm looking to spend $ 30.
3. On the inner pages, I need to be enter the project title, the estimated final price of the project, all the separate expenses, and all the separate income
4. Each tab should be a different project
5. Projects (tabs) should automatically be in alphabetical order
6. Each time I create a new tab, the default template needs to be there.
I'm looking to spend $ 30.
Business List / Excel Spreadsheet
one number, email address, business address and owner's name for the following professions in Florida:
1. Dietitians
2. Personal Trainers
3. Weight Loss Centers
4. Fitness Gyms
If you have a program that can gather public information online and you know how to use it, please feel free to place your bid and place the requested information in categories on an excel spreadsheet for me.
Thanks,
Emil Clemons
1. Dietitians
2. Personal Trainers
3. Weight Loss Centers
4. Fitness Gyms
If you have a program that can gather public information online and you know how to use it, please feel free to place your bid and place the requested information in categories on an excel spreadsheet for me.
Thanks,
Emil Clemons
Copy Menus into Excel Spreadsheet
cy or I reserve the right not to pay for that menu.
This is ongoing work. Initially I have around 500 menus so it is worth $ 500 AUD in total, but moving forward I will have thousands of menus to enter. This work is on going - I am looking for someone who is looking for continual work entering these menus.
Please contact me with any questions.
This is ongoing work. Initially I have around 500 menus so it is worth $ 500 AUD in total, but moving forward I will have thousands of menus to enter. This work is on going - I am looking for someone who is looking for continual work entering these menus.
Please contact me with any questions.
Cut & Paste information from www.goldenpages.ie to an excel spreadsheet
to get both email and mobile phone number along with the other details as listed in the excel spreadsheet. For your information all mobile phone numbers in Ireland begin with the following prefixes, 083,085,086,087 and 088.
http://www.goldenpages.ie/search/Ireland/electrician.html (It shows here that there are 1758 contacts available here)
http://www.goldenpages.ie/search/Ireland/Plumbing_contractors.html (This category shows 1616 contacts)
http://www.goldenpages.ie/search/Ireland/electrician.html (It shows here that there are 1758 contacts available here)
http://www.goldenpages.ie/search/Ireland/Plumbing_contractors.html (This category shows 1616 contacts)
excel spreadsheet
Need excel spreadsheet for financial stocks tracking.
information should include:
name of company
how many shares purchased
current price paid price
etc......
Here is an example below:
http://www.spreadsheets.net/StockFetcher2.GIF'
This is an easy project.
information should include:
name of company
how many shares purchased
current price paid price
etc......
Here is an example below:
http://www.spreadsheets.net/StockFetcher2.GIF'
This is an easy project.
Need fairly basic Excel Spreadsheet by inita
ense.
Also, if it matters - I will use this spreadsheet on both a mac computer and a PC (Mac at home, PC laptop when out but will need to make changes to the file while out and then update the mac file when I return by saving over the previous file.
PLEASE REPLY WITH A BRIEF EXPLAINATION OF HOW YOU'D CREATE THIS SPREADSHEET SO I'LL KNOW WE'RE UNDERSTANDING EACH OTHER AND ALSO PLEASE DO SUGGEST ADDITIONS THAT YOU THINK MIGHT BE USEFUL AS WELL. THANK YOU.
Also, if it matters - I will use this spreadsheet on both a mac computer and a PC (Mac at home, PC laptop when out but will need to make changes to the file while out and then update the mac file when I return by saving over the previous file.
PLEASE REPLY WITH A BRIEF EXPLAINATION OF HOW YOU'D CREATE THIS SPREADSHEET SO I'LL KNOW WE'RE UNDERSTANDING EACH OTHER AND ALSO PLEASE DO SUGGEST ADDITIONS THAT YOU THINK MIGHT BE USEFUL AS WELL. THANK YOU.
Zigzag Indicator For Use In Ms Excel Spreadsheet
use just one component of the OHLC data series or the OC or HL combination for identifying the zig zag points.
I'd like to identify each turning point as a top or bottom (peak or valley). This can be done via inserting a +1 (for peak) or -1(for valley) in an adjacent cell.
The code/programming must be efficient and fast. If your code works well, this may be ported to another programming language as a subroutine or module. This will be a separate project.
I'd like to identify each turning point as a top or bottom (peak or valley). This can be done via inserting a +1 (for peak) or -1(for valley) in an adjacent cell.
The code/programming must be efficient and fast. If your code works well, this may be ported to another programming language as a subroutine or module. This will be a separate project.
