Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel for Mac automated data transfer
Sign in to Add to Watch List

Finance & Management > Investment Analysis

View Change History

The client has made the following changes to the job.


Job awarded.

Jun 13, 2014

Job Description

  |  Change History >>


  • Posted: Fri, Jun 13, 2014
  • 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: $100 - $250
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Daily, I output stock market transactions from TDAmeritrade's Think or Swim platform. I can export a fairly complex cvs file that can be imported into Excel for Mac. There is an area of the resulting spreadsheet that has the same header, that lists the stock transactions for the day. Listed in columns are several values such as stock symbol, prices, type of transaction, date and time, etc.

I would like either an applescript, or Excel automation that will automatically go out to the cvs file, or spreadsheet after import, find the data for the day, extract, and place the data into another spreadsheet.

Essentially, I don't like how Think Or Swim presents the reports, and want to customize my trading history. I can provide a sample of the TOS cvs file, imported spreadsheet, and example of the target spreadsheet, of what it should look like for at least a few transactions.

Further, it would be helpful to have an applescript that I run at a set time that will open TOS, export t...

Sign in or Register to see more

Desired Skills
Application Programming
Job ID: 58169729
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Bachelors of Business Administration: Accounting. Film Producer. Business Manager for Artists and Creatives. I'm an accountant from Los Angeles....
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 58198260  |  Submitted: Jun 13, 2014 13:53 ET 
Proposal SEALED

 Kenya  |  
Bookkeeping, Accounting, Financial Analysis, Modeling and Forecasting, Wave, Quickbooks Desktop, Quickbooks Online Xero, Excel, Quicken, MYOB, and...
 4.9   |  Private   |  30 Jobs
Bid ID: 58179416  |  Submitted: Jun 13, 2014 05:15 ET 
Within 3 days
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 »