Data Analysis And Charting

Will send report that show the details of a number of currency trades (which currencies were purchased, which were sold, when, for how much etc). Based on this data, I need an excel spreadsheet that calculates the following data (on different pages, but linked to the same data). The data should not be re-entered -- because that can result in data entry errors. Accuracy of work is extremely important. After I do this first report, I will then narrow down the statistics that will be most important to track on a routine basis and will then narrow this list down considerably and then create a regular monthly update project after the end of each month.

Equity curve by date (plots weekly equity in a linear graph over the time of analysis)
Daily returns - using 5pm EST (use Alpari test account to get data feed for forex)
Total # of trades
Total # of trades by currency pair
Profitable trades as a % of # of trades
Profitable trades as a % of # of trades per currency pair
Total USD volume traded (count each side)
Total # of contracts traded (count each side)
Total USD volume traded by currency pair
Total # of contracts traded by currency pair
Average size (USD) per trade
Average size (USD) per winning trades
Average size (USD) per losing trades
Average size (pips) per trade
Average size (pips) per winning trades
Average size (pips) per losing trades
Histogram of trade sizes (all trades)
Histogram of trade sizes (winning trades)
Histogram of trade sizes (losing trades)
Histogram of times of day that all the trades were initiated
Histogram of times of day that the winning trades were initiated
Histogram of times of day that the losing trades were initiated
Average trade length in hours (to one decimal place)
Average trade length in hours of winning trades
Average trade length in hours of losing trades
Average trade length in hours (to one decimal place) -- subtracting out weekends
Average trade length in hours of winning trades -- subtracting out weekends
Average trade length in hours of losing trades -- subtracting out weekends
Average size (USD) per trade - per currency pair
Average size (USD) per winning trades - per currency pair
Average size (USD) per losing trades - per currency pair
Average size (pips) per trade - per currency pair
Average size (pips) per winning trades - per currency pair
Average size (pips) per losing trades - per currency pair
Histogram of trade sizes (all trades) - per currency pair
Histogram of trade sizes (winning trades) - per currency pair
Histogram of trade sizes (losing trades) - per currency pair
Histogram of times of day (rounded backwards to nearest hour) that all the trades were initiated - per currency pair
Histogram of times of day (rounded backwards to nearest hour) that the winning trades were initiated - per currency pair
Histogram of times of day (rounded backwards to nearest hour) that the losing trades were initiated - per currency pair
Average trade length in hours (to one decimal place) - per currency pair
Average trade length in hours of winning trades - per currency pair
Average trade length in hours of losing trades - per currency pair
Average trade length in hours (to one decimal place) -- subtracting out weekends - per currency pair
Average trade length in hours of winning trades -- subtracting out weekends - per currency pair
Average trade length in hours of losing trades -- subtracting out weekends - per currency pair

It is helpful if you have some understanding of forex and trading in general. The data needs to be presented in a format that makes it easiest to assimilate the data (formatted data tables, or graphs or histograms).

Search All Jobs:

Sales Person - Human Body Analyst Machine

We are a Manufacture of the Latest Non-Invasive Equipent for Bio-Resonance Analysis, Therapy, Suggestions of Nutrition Supplements, and Remedy Preparation of the Human Body. NOTE: Our Machines are generaly not for Hospitals. They are used most often in Private Practices...

Skills Required: analysis sales
  • Fixed Price Project
  • Max $50000
  • 2 years, 6 months left

Financial Analyst

I need 10 full time Financial Analysts to work with me. The Financial Analysts will be part of a pioneering group. Successful candidates will perform high level financial analysis of portfolio assets and serve as financial advisors to global underwriters...

  • Fixed Price Project
  • Max $1000
  • 10 years, 4 months left

Data Entry Of Tax Returns And Profit And Loss Statements To Software Tool

I need someone who is very familiar with Schedule C profit and loss statements and Quickbooks Profit and Loss statements to migrate these reports into a software tool in-house. This is a fixed price job. I am open to bids...

  • Fixed Price Project
  • Max $25
  • 1 month, 4 weeks left

Financial Analyst - Financial Institutions

I need experienced Financial Analysts who will form as my Financial Institutions group and be willing to be trained by me. Successful candidates can look forward to performing high level research, financial analysis and function as financial advisors to global underwriters...

  • Fixed Price Project
  • Max $1500
  • 10 years, 4 months left

Sale Lead Generator

We are looking for a self motivated individual to find leads of manufacturers who have excess/close out inventory for sale in the United States of America. List of potential clients may be provided. With each lead that results in a sale, you will receive $25 financial compensation...

  • Fixed Price Project
  • Max $75
  • 4 years, 4 months left

Start-up Fund Looking For Limited Partners

Hello, We are an incubator start-up fund currently seeking traders wishing to become limited partners. We currently have all necessary legal structuring in place, including our LLCs and counsel...

  • Fixed Price Project
  • Max $50000
  • 5 years, 3 months left

Sale Lead Generator/ Appointment Setting

We are looking for a self motivated individual to find leads/ appointments of manufacturers who have excess/close out inventory for sale in the United States of America. List of potential clients may be provided. With each lead that results in a sale, you will receive $25 financial compensation...

  • Fixed Price Project
  • Max $200
  • 4 years, 4 months left

Decode Typist

Only apply if you are an independent decoder. We need many responsible typists. Great applicant will be a priority. After passing the easy interview you will be hired.......

Skills Required: data-entry
  • Fixed Price Project
  • Max $200
  • 5 years, 1 month left

Long-term Reliable Academic Writers Needed

PLEASE ONLY APPLY IF YOU ARE SERIOUS AND RESPONSIBLE ABOUT WORKING ONLINE AS AN ACADEMIC WRITER! THANKS!! We are looking for a lot of good writers to work with us in the long term...

  • Fixed Price Project
  • Max $60
  • 7 months, 4 weeks left

Generate Leads And Close Sales

We require an agent who can successfully generate leads and close sales for Long-Distance Reiki Sessions provided by a Reiki Master of 20 years (sessions priced at a rate of $60.00 USD per hour with a 1 hour minimum). 10% paid to the Closer on every completed transaction. All applicants must include

  • Fixed Price Project
  • Max $5000
  • 1 year, 1 month left

Job Details

  • Job Type
  • Fixed Price Job
  • Budget
  • Max $50
  • Start Date
  • 12/20/2011 07:37:30 AM
  • Job Status
  • Job Expired