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:

Our Transcription Team Is Growning. Join Us (usa Only)

Our team is looking for experienced transcribers. There is work available to be done daily. You must be willing to join our team as exculsive affilate. I will assign work to you as I get it in. You must be available at least three days per week. Weekend work is required...

  • Fixed Price Project
  • Max $15
  • 6 years, 8 months left

Bulk Order Articles

We are looking for a number of writers (10-15) who can handle bulk work daily to join our team, need to be passionate about writing and can handle any kind of writing work at any given time they are required. English is a plus plus. Must have passed U.S basic skills test as well...

  • Fixed Price Project
  • Max $500
  • 10 months, 1 week left

Retargeting Adv System To Www.tradtuber.com Development

Dear friend due to our site www.tradetuber.com fast growing to meet our member adv display needs now we need one professional ad system all that function like adready.com system , we are open to invite professional workers to fulfill this program details needs pls refer to adready site ...

  • Fixed Price Project
  • Max $1000
  • 2 days, 19 hours left

Smart Person With Excel Experience Needed For Recurring Data Analysis Project

I need someone to analyze information in Excel on a monthly basis. I will be sending them monthly sales data for a few dozen companies and I need that data put into easy to digest graphs within 12 hours...

  • Fixed Price Project
  • Max $1500
  • 1 week, 2 days 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
  • 10 months, 1 week left

Small Cap Journalist

Hello there and thank you for your interest. :) We're looking for skilled writers, with experience evaluating investments of U.S. equities and extremely well versed in English who can write 700-1000 word articles with the following criteria: U.S...

  • Fixed Price Project
  • Max $15
  • 1 month, 2 weeks left

Options Analysis

Required for initial ground level start. Stand alone Desktop application for the data mining, analysis and production of buy /sell order sequence of ASX (stock market) focused in the options market, including Indices.Level of statistical understanding with analysis required ...

  • Fixed Price Project
  • Max $10000
  • 2 months, 1 week 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, 8 months left

Seeking Analysts, Trading Signal Providers, Trading System Developers

Hello, We are an established trading and research firm with deep experience in FX, futures, equities and options. We are currently expanding our web base with a new site that will be directed towards traders looking for proven systems and research...

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

Writer/economics And Managing Editor

WRITER/Managing Editor for Website There are two positions, which could be filled by two people, or one experienced individual. 1. Contract work for accomplished writer/editor to write articles on the latest economic and investment developments in Asia/China...

  • Fixed Price Project
  • Max $120
  • 5 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