How to learn "Using excel for trading"

[EdgeHunter]

Quote from newguy1:

can you use excel or some kind of programming indicator to separate and add up the transactions in a Time and Sales window.

Is there an indicator for this already? Something that would say:

stock: LU

NYS: red prints 800k green prints 90k

PSE:

CHX:

ect, ect, ect.

basically, is there anything that can be used to add up time and sales by different categories in real time?

If not, is it possible to code this in some language? If so, which language?

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