How to learn "Using excel for trading"

Discussion in 'Educational Resources' started by Nana Trader, Jul 26, 2005.

  1. Yes, possible to do in Excel (Just about any math is possible in excel - just don't use it as the database) if you can get the Bid Price, Ask Price and Last Price on the same data stream record...

    If you are getting all that data then just compare last price to see if it went off at bid for sell or ask for buy then note it as 1 for buy or -1 for sell and then save results to MSDE dbase or Access or mySql database and then chart in some package or create a report...

    For trades that go off inbetween bid price and ask price (A Lot of them do) then it's fuzzy as to their sell / buy status...

    hthelps...

    :)

    cj


    __________________
    HAVE STOP - WILL TRADE

    If You Have The Vision We Have The Code
     
    #21     Jul 27, 2005