Adjusting VBA code to go to first free cell down

Hi all,

I write with the following problem: I wrote a VBA code in Excel but I cannot adjust some things and I will be grateful if you can help me. So, can be added to vba code to do the following:
1. Macros FillPrices - after filling data to go to first free cell to be ready for use next day.
2. Macros FillPrices - after filling data conditionanally formating in red if used formula (true condition of IF operator).
3. Macros FillIndices - after filling data to go to first free cell to be ready for use next day.

I attach an example file.

Thanks in advance.