Thread: Excel help
View Single Post
Old 06-19-2007, 03:56 AM   #1 (permalink)
AspeK
SBR Rookie
 
Join Date: 05-07-07
Location: Canada
Posts: 19
AspeK is offline
Default Excel help

I was using the old pen and paper and now I want to use Excel but while trying to do a sheet I have some trouble doing things. I would need some help to do some things:

1) Each time I start to write my matchup info in column 2 I want column 1 to be autofilled with todays date. So I want an autofill A for function today each time I start writing in B

2) I want to do some letter shortcuts ex: I write m and enter and its write moneyline or r (enter) and its write Runline

3) Something a little bit more complex, I want a TOTAL DAY PROFIT row who will sum all the profit made that day.

4) And finnaly I dont know if we can do this but can I have for my TOTAL DAY PROFIT the money and unit profit in the same cell separed with a backslash? EX: +200$/+2.0u or -1243$/-5.2u

Thank you very much guys

Last edited by AspeK; 06-19-2007 at 04:00 AM..
Reply With Quote