Closed

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
Employer working
Project Budget
₹600 - ₹1500 INR
Total Bids
1
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.
thanks,

jimbob

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