ElectricSavant Apr 13, 2006 #21 Working on some formula's Attachments kastro.xls kastro.xls 22 KB · Views: 78
ElectricSavant Apr 14, 2006 #23 type in a positive p/l in that column or a negative...I put in some automatic conditional formatting...do you like that? Attachments kastro.xls kastro.xls 22 KB · Views: 75
type in a positive p/l in that column or a negative...I put in some automatic conditional formatting...do you like that?
J JMowery1987 Apr 14, 2006 #24 I just got one question ES. How do you do the automatic color formating? I've been interested in that awhile. BTW, I attached a basic Excel SS I have been working on to keep track of my trades for the Laser platform. I will add in all the formulas when I can. But still new with excel though. I'd still really be interested in knowing how to do the color formatting. Color the background if negative on the P&L and Green if positive. Stuff like that EDIT: I just noticed we are tearing up the Forex scalping thread with Excel stuff Attachments equities trading new.xls equities trading new.xls 14.5 KB · Views: 108
I just got one question ES. How do you do the automatic color formating? I've been interested in that awhile. BTW, I attached a basic Excel SS I have been working on to keep track of my trades for the Laser platform. I will add in all the formulas when I can. But still new with excel though. I'd still really be interested in knowing how to do the color formatting. Color the background if negative on the P&L and Green if positive. Stuff like that EDIT: I just noticed we are tearing up the Forex scalping thread with Excel stuff
Kastro_316 Apr 14, 2006 #25 That's perfect, I like it! What is the new section to the right you put in? -Kastro
ElectricSavant Apr 14, 2006 #26 Fixed a formula j Mowery: look under format and choose conditional formatting... Attachments kastro.xls kastro.xls 23 KB · Views: 70
J JMowery1987 Apr 14, 2006 #28 Awesome ES, works perfectly. Now if only I could figure out how to program in Visual Basic to make those macros then I could automate with the Laser platform
Awesome ES, works perfectly. Now if only I could figure out how to program in Visual Basic to make those macros then I could automate with the Laser platform
ElectricSavant Apr 14, 2006 #29 That will cost you... Quote from JMowery1987: Awesome ES, works perfectly. Now if only I could figure out how to program in Visual Basic to make those macros then I could automate with the Laser platform More...
That will cost you... Quote from JMowery1987: Awesome ES, works perfectly. Now if only I could figure out how to program in Visual Basic to make those macros then I could automate with the Laser platform More...
ElectricSavant Apr 14, 2006 #30 Folks..I am not for hire at any price, please do not PM...sorry do not mean to be rude...I have an extremely full plate just now...I am a trader for gawds sakes... just having a little fun in Excel...
Folks..I am not for hire at any price, please do not PM...sorry do not mean to be rude...I have an extremely full plate just now...I am a trader for gawds sakes... just having a little fun in Excel...