Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Excel Macro - agrregate trading data for charting and e-mail
Sign in to Add to Watch List

Finance & Management > Financial Reporting

View Change History

The client has made the following changes to the job.


Job canceled.

Jun 14, 2011

Job Description

  |  Change History >>


  • Posted: Wed, Jun 08, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

We want to provide raw trading data to an excel spreadsheet.

Macro code you write will sum the data and extract relevant detail to present the data into a template that you develop.

This tempate will then act as the basis of an HTML e-mail senty through outlook.
You will develop the code that takes the excel content and creates the outlook e-mail.

Attahced is a data sheet with sample trading data mentioned above. Below is a detaile dlist fo tasks relating to that data.

Extract unique constituents of column E – defined as Venues

Extract B/S (replace with Buy/Sell) from column B – defined as Buy/Sell

Extract most recent date from Column F - defined as Trade Date

Extract most recent date time from Column F – defined as First Execution

Extract oldest date time from Column F – defined as Last Execution

Calculate Sub Total column C data by unique constituents of column E – defined as Volume Traded

Calculate % of Total Vo...

Sign in or Register to see more

Job ID: 24625993
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
ExcelPower provides consulting services that help you unleash your best ideas, get things done and puts you on top of your business using simple...
 0.0   |  Private   |  0 Jobs
Bid ID: 24640836  |  Submitted: Jun 9, 2011 00:16 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »