I need a really simple spreadsheet....

[robfosters]

but my Excel skills suck

Basically, it's to track daily betting.

I need four currency columns. Stakes, Return, Daily P/L and Running P/L. The stakes column needs to be negative value so I don't have to type a minus sign in every time.

I imagine it's pretty self explanatory what I'm looking for. So grateful if anyone can help.

Thanks.

 

[robfosters]

Are you kidding me? Why not do it yourself? Are you stupid or extremely lazy?

robfosters
-----
Occupation
Unemployed at present

There's no need for that. That's just spiteful. I'm unemployed due to serious disability (stroke, heart disease). I actually used to be in the diplomatic service. But lets not let that get in the way of an insult eh.

I have tried, but I just do not understand excel. Word, I'm fine with. But Excel. I just fail completely.

 

[robfosters]

What formulas do you want for Return, Daily and Running?

At the moment I have this (random values inputted)

Not sure if I can do stakes negative and currency at the same time.

This looks exactly what I want. If the stakes were negative and we entered a new line on 3, I assume C3 would be (A3+B3) and D would be D2 plus C3.

 

[robfosters]

If your currently unemployed then you have plenty of time to learn. The functionality you are after is among the most basic that excel offers, getting to grips with it will allow you to plan your finances much more efficiently

I don't believe this thread. I ask for a simple bit of help. the likes of I would be more than glad to provide others, and all I get is lifestyle advice and a character assassination.

 

[robfosters]

The stakes can be positive, you just need to use a formula to calculate the other cells.

I'll do it in the morning if someone else doesn't get to it first.

Thanks for your offer Gilly, but I did manage to do it myself in the end. I never realised that when you copy and paste formulas, it automatically adjusts the cells it calculates. That makes it really easy.

However, I still haven't found a way of entering negative numbers automatically.

 

[robfosters]

Course you can, that's exactly what the custom formatting is for!



Why bother, just use the custom formatting for cells and use:

-£#,##0.00

Thanks Paradigm,

Why that does indeed turn everything into a negative, for some bizarre reason, the auto sum still treats it as a positive, so even though I have -£20 in the stakes column and £20 in the returns column, it still sums it at £40 rather than £0.

I've tried ways that I've found online, yet none of them work. I thought this would have been very easy to accomplish.

 

[robfosters]

Leave the stake as positive. Then under cell D2, enter the following formula -

=SUM(-A2+B2)

I think you need an additional column to show daily (as opposed to overall) stakes. You will then be able to enter a formula for Daily P/L.

I thought this after. I mean, a stake still is a positive number. It's not negative. So I left it as a currency cell and altered the formula slightly. In the end I have ended up with something like this. Bit loud I know, but I find it easy enough to read and manipulate.