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:

Virtual Assistant

Im looking for an on-going virtual assistant for 2 hours a week to help with simple side projects. Respond to this job posting with your Skype ID so that I can give you your first assignment.

  • Fixed Price Project
  • Max $5
  • 4 months left

Article Writing SEO Professional

Needs to be very familiar with marketing fundamentals - not just a technical SEO This is a permanent full time job...

  • Fixed Price Project
  • Max $180
  • 5 months, 1 week left

Skilled Python/django Developer Monthly Full Time

Looking for long-term relationship with skilled developer.. From us: - Ability to build "development process of your dream" - Work on a new product - $ 1.5-2...

  • Fixed Price Project
  • Max $2000
  • 6 months left

Investor Buyers List Creator

I need a real estate investor buyers list for my wholesale real estate deals. I need somebody EXPERIENCED who can create a buyers list in multiple cities in different US states on the east coast...

  • Fixed Price Project
  • Max $20
  • 2 years, 8 months 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
  • 11 years, 4 months left

Data Entry Long Term Newbies Welcome

First goto the link goo.gl/of6gEi and register Read the following instructions carefully A notable internet company, based in the San Francisco Bay Area, currently needs a Data Specialist. You will be adding to, editing and merging data in a large database of international topics...

  • Fixed Price Project
  • Max $2000
  • 2 weeks, 5 days left

Data Mining For Building Owners

A team of us would need approximately 400 phone numbers per month for building owners in selected areas or selected building types...

  • Fixed Price Project
  • Max $1000
  • 3 months left

Lead Generator Needed/ Gift Card Program

You will be dialing from a list on Callfire as well as direct dials to customers (via Magic Jack for instance). You will be offering $50 dining gift cards as well as $50-$100 Visa gift cards in exchange for a free quote and application of life / health insurance with one of our contracted agents...

  • Fixed Price Project
  • Max $120
  • 1 month left

Newbie Punjabi Translator (only Indian)

we need Punjabi translator for translation for regular projects. (No Pakis, bangladeshi people please) It will be a permanent job as long as you want ! We will pay you 50 Rs for 250 to 299 words as per your quality. which may be increased. We also pay bonuses upto 50% if we liked your job...

  • Fixed Price Project
  • Max $50
  • 2 weeks, 1 day left

Inside Sales

Real Estate brokerage looking for someone with 3+ yrs experience making calls recruiting agents, getting listings, talking to leads who are in foreclosure, behind on their mortgage and are upside down on their mortgage. Someone who knows how to do CMAs and sales presentation package.

  • Fixed Price Project
  • Max $50000
  • 2 months left

Job Details

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