sharetrader
Results 1 to 13 of 13
  1. #1
    Senior Member
    Join Date
    Jun 2004
    Location
    , , New Zealand.
    Posts
    1,146

    Default spreadsheet - excel

    Can anyone poit me in a direction where I can get instructions on how to do speadsheets on excel

    thanks
    He who lives by the crystal ball soon learns to eat ground glass. (Edgar Fiedler)

  2. #2
    Senior Member
    Join Date
    Jul 2007
    Location
    North Shore
    Posts
    1,219

    Default

    Maybe one of those free computing courses?

    There's also a guy called excel trader who trades a live automated system entirely in excel.
    Disclaimer: Do not take my posts seriously. They are only opinions.

    AMR has sold all shares and is pursuing property.

  3. #3
    Guru
    Join Date
    Feb 2005
    Location
    Auckland
    Posts
    3,164

    Default

    Quote Originally Posted by Mick100 View Post
    Can anyone poit me in a direction where I can get instructions on how to do speadsheets on excel

    thanks
    http://www.amazon.com/Excel-2007-Dum...5357502&sr=1-1
    Free delivery worldwide with Book Depository http://www.bookdepository.co.uk

  4. #4
    Senior Member
    Join Date
    Jun 2004
    Location
    , , New Zealand.
    Posts
    1,146

    Thumbs up

    Thanks CJ

    I see my local library has got a heap of books, including the one you reccommended, on excel instruction
    He who lives by the crystal ball soon learns to eat ground glass. (Edgar Fiedler)

  5. #5
    Guru drillfix's Avatar
    Join Date
    May 2008
    Posts
    4,834

    Default

    Mick, sometimes its as easy to take somebodies already made spreadsheet and then study how it was made.

    At the same time you need to become either more, or very familiar with the Excel Program.

    Can you advise what type of spreadsheet you are after?

    If you are after one that is for tracking your trades, I downloaded one from a trader in the US from his blog.

    If you want, I could attach the file here, if that is what you really wish to achieve.

    Cheers for now~!

  6. #6
    Member
    Join Date
    Mar 2002
    Location
    Auckland, , New Zealand.
    Posts
    276

    Default

    Some good advice already, as well use the Excel help function, I have found the solution to almost all diffiulties there.

  7. #7
    Senior Member
    Join Date
    May 2000
    Location
    New Zealand.
    Posts
    1,321

    Default

    Quote Originally Posted by drillfix View Post
    If you are after one that is for tracking your trades, I downloaded one from a trader in the US from his blog.

    If you want, I could attach the file here, if that is what you really wish to achieve.
    Throw it up as it's always good to see a different way of doing things...

    Death will be reality, Life is just an illusion.

  8. #8
    Member whirly's Avatar
    Join Date
    Sep 2007
    Location
    Greymouth
    Posts
    310

    Default

    On the subject of spreadsheets I currently use this position size calculator. http://forum.incrediblecharts.com/me...ion-249749.xls (It is only a 30k download).

    Anyone have any comments.

    I'd be interested in how others set initial stops and especially targets. I usually just use previous support and next resistance points respectively...but this can be a fairly limited range so I then look at the next level of support and resistance. Ideas?

    Enjoy.

    Whirly
    Last edited by whirly; 03-10-2009 at 10:04 AM.

  9. #9
    Member Novitiate's Avatar
    Join Date
    May 2009
    Posts
    56

    Default Excel spreadsheet

    If you want, I could attach the file here, if that is what you really wish to achieve.

    Cheers for now~![/QUOTE]


    Would be great to have a look at this spreadsheet, if poss. My Excel skills could do with some guidance from a well-built spreadsheet.

  10. #10
    Guru drillfix's Avatar
    Join Date
    May 2008
    Posts
    4,834

    Default

    Sorry for the delay folks, I totally forgot that I posted on this thread..lol ooppss

    Please note that this was taken from a trading blog from somewhere on the web that I come across so I take no credit for actually doing this, but hope it comes in handy for those who find it useful.

    Attachment 2084

    Pass it around or Enjoy.

  11. #11
    Senior Member
    Join Date
    Mar 2001
    Location
    Auckland, , New Zealand.
    Posts
    1,325

    Default

    Quote Originally Posted by drillfix View Post
    Sorry for the delay folks, I totally forgot that I posted on this thread..lol ooppss

    Please note that this was taken from a trading blog from somewhere on the web that I come across so I take no credit for actually doing this, but hope it comes in handy for those who find it useful.

    Attachment 2084

    Pass it around or Enjoy.

    Does not want to open df
    says folder is empty

    Works now for some reason Thanks df
    Last edited by Jay; 14-10-2009 at 12:00 PM.

  12. #12
    Member Novitiate's Avatar
    Join Date
    May 2009
    Posts
    56

    Default

    Thanks for that, drillfix - it worked for me. I'm on a Mac, so maybe it was created on Mac.

  13. #13
    Guru drillfix's Avatar
    Join Date
    May 2008
    Posts
    4,834

    Default

    No worries guys, glad its working fine for ya.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •