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:

[Adult Content] General Web Data Entry

This job is for general data entry to schedule updates for 4 websites. The basic procedure is as follows: ------ Open data file; $1 - paste in about 15 fields, submit the form. Modify about 6 fields and submit the form a second time Modify about 6 more fields and submit the form a third time...

Skills Required: data-entry english training video
  • Fixed Price Project
  • Max $5
  • 1 year, 3 months left

Full Time Philippines Based Joomla, Php, HTML, CSS Website And , Apple/Android Apps Project Coordinator

Looking for a full time website / app project coordinator with the following experience from Philippines - Understanding of Joomla, Php, CSS and HTML website development - Understanding of Iphone/Andriod app development - Good communication skills in English - Ability to coordinate with offshore...

  • Fixed Price Project
  • Max $400
  • 3 months, 1 week left

Forex Trader Data Entry

To enter trades when we instruct and to manage trades as per our instructions .Managing includes entering and exiting (using stops , break even , exiting per exit rules and trailing.). Trader must be available via Skype , have broadband and computer access 24 hours a day...

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

Technical Writter

Hey, I am looking for technical writers for my website. The topic is fitness. I will provide you with articles and your job will be to re-write them in your own words. The articles have to be 400 - 500 words long and we pay $10 - $12 per article...

  • Fixed Price Project
  • Max $50000
  • 1 month, 1 week left

Researcher

I am looking for an energetic researcher to find 1000 businesses with blogs. I need someone who has very good communication skills. Please apply with samples of research you have done. I will provide more details once hired.

  • Fixed Price Project
  • Max $50
  • 6 days, 12 hours 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
  • 1 month, 1 week 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
  • 1 month, 1 week left

Respond To 100 Emails Per Day Using Templates

Language International needs a diligent, detail-oriented long-term contractor to draft responses to 100 emails per day from schools with whom we are interested in establishing partnerships. TO APPLY, YOU MUST COMPLETE A TEST...

  • Fixed Price Project
  • Max $200
  • 3 months, 1 week left

Seeking A Good Personal Assistant

I am seeking a Personal Assistant to help me manage my personal life: This person will help me do the following: - Search for discount flight tickets and vacation on the internet...

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

Job Details

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