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:

Set Up Clients On 5 Different Websites

I require an english speaking person who can enter a businesses details across up to 5 different sites. Google places, Trip Advisor, Urban Spoon, Yelp & Four Square. You will be provided with step by step instructions for each different platform - please see document attached. You will be paid p

  • Fixed Price Project
  • Max $20
  • 1 week, 4 days left

A Professional Job Application Writer Needed For Long Term

I want someone who can apply to several jobs from multiple profiles of me using my id and password. This is a very simple job which only requires good English. Payment will be commission based. The contractor will receive 10% commission of every successful job I can get...

  • Fixed Price Project
  • Max $100
  • 3 months, 4 weeks left

EBAY Lister, LISTING Manager Associate

This is an ongoing position. We are in need of an Ebay Lister. This is part-time work for someone who understands how to list on Ebay and price items so that we are profitable...More details and listing/product requirements will be provided...

  • Fixed Price Project
  • Max $25
  • 4 weeks left

Mystery Shoppers

Dear Sir/Madam, Parkway consulting firm needs mystery shoppers From any where in U.S , as part-time worker. No application fee Required, Applicant must be 18 years and above, must check email 2 -3 times in a day to read updates from us and be honest...

  • Fixed Price Project
  • Max $300
  • 6 years left

Newbie Hindi Translator.

I need a english to hindi translator on permanent basis !! we Hire translators on daily basis who can produce quality work. I will pay you 1$ for 499 words plus bonuses !! It will increase as we go along ...

  • Fixed Price Project
  • Max $50
  • 1 week, 3 days left

Newbie Hindi Translator.

I need a english to hindi translator on permanent basis !! we Hire translators on daily basis who can produce quality work. I will pay you 1$ for 499 words plus bonuses !! It will increase as we go along ...

  • Fixed Price Project
  • Max $50
  • 1 week, 3 days left

A Professional Job Application Writer Needed For Long Term

I want someone who can apply to several jobs from multiple profiles of me using my id and password. This is a very simple job which only requires good English. Bid with your rate for writing 50 cover letters. NO UPFRONT PAYMENT...

  • Fixed Price Project
  • Max $5
  • 3 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
  • 2 years, 1 month left

Looking For Talented, Experienced, Communicative And Reliable Virtual Assistants.

Looking for talented, experienced, communicative and reliable Virtual Assistants. No companies' only individuals - approximately 30 hours per week to start .This will be a challenging & exciting role. Guaranteed long term project , with bonuses...

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

Customer Service/admin Assistants

We're hiring customer service reps and admin assistants for our online projects. These are long term positions so if you do well it can turn out to be steady income for you. Your job will include gathering data, and storing data, as well as various other duties...

  • Fixed Price Project
  • Max $100
  • 1 month, 3 weeks left

Job Details

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