Help copying a formula pattern and colour fill

So I'm pretty much self taught, I can work my way around a spreadsheet but I don't know the quickest most efficient ways so I thought I'd come ask a true expert.

The screen shot below shows what I'm currently working on for a professional sports tipster, now I know what to do and how to do it but doing it fast and with 0 errors is another story.

Now 01.08.2018 is formulated and setup correctly as is 02.08.2018 now the only problem I'm having is when I try highlight and drag to auto formulate its messing the colours up, and also its not copying the pattern so the data is wrong. How can I do this more accurately so it copies the pattern.

Further details, I'm basically trying to work out the strike rate for certain units which we use to bet with so for example 1 unit is £20, 0.5 units is £10 etc etc. So all i want to do is input the data from the daily tracker to the chart but of course theres 29-31 days in a month so as its a new feature I'Screen Shot 2018-08-15 at 19.12.39.pngm trying to catch up and I'm just trying to get the pattern to copy suit so chart 1 is from day one, chart 2 is day 2 and I want to drag it down and it automatically pull data from the remaining days. Not because I'm lazy but because it will mean a lot less errors if i have to manually input it.

posted twice please delete this one. sorry