176985602337900

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.

Description
Date

Job canceled.

Jun 14, 2011
Close

Job Description

  |  Change History >>

Updated

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

    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.

Tasks
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
Proposals
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...
7
  |  
 0.0   |  Private   |  1 Jobs
Bid ID: 24640836  |  Submitted: Jun 9, 2011 00:16 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »