Trading Spreadsheet - repost

This project received 1 bids from talented freelancers with an average bid price of ₹15000 INR.

Get free quotes for a project like this
Project Budget
₹600 - ₹1500 INR
Total Bids
Project Description

I want a spreadsheet to record stock, option and dividends, (and perhaps anciliary trading corporate actions/spinoffs).

I can not imagine it is too expensive a project but is a little beyond me !! I assume below $250.

I will attach my most recent effort. i am looking for enhancements / improvements. It seems unusually large to me at 15 Meg?

My formatting is a bit dodgy.

I would like it scaleable to > 100 securities.

perhaps some dropdown lists for option positions... assigned / expired / covered / exercised.

Also, some stocks are USA and some UK and some AUD. The summary needs to be able to recognise that easily ?

Can it be linked to an external source for delayed prices to perhaps update stock prices at least? And if possible option prices (delayed) or a simple in the money calculation?

And a summary page of short calls, short puts, long call, long puts ??

Any thoughts or improvements / ideas appreciated. My spreadsheet is a starting point maybe ?

this is my first go at freelancer.



Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online