To all who think this is a good idea, your more than welcome to download this excel sheet and copy the conditional formatting and to those who care less... don't download it
I made the cells change color when they either become a greater value than the cells above or a less value than the cells below. Green cells mean the pair moved up and red cells mean the pair moved down.
If you want to copy the formatting to another spreadsheet you can copy and paste special. I made other modifications to the data feeds so the entire spreadsheet might not work properly for most of you. If you copy the conditional formatting make sure the row numbers line up otherwise it will be all messed up. Column letter does not matter.
I also moved the profit to the left side and the pair to the right. This makes it easier to sort... you can highlight the entire block for each date, go to the data tab and sort z to a, one simple click.
Luke
I made the cells change color when they either become a greater value than the cells above or a less value than the cells below. Green cells mean the pair moved up and red cells mean the pair moved down.
If you want to copy the formatting to another spreadsheet you can copy and paste special. I made other modifications to the data feeds so the entire spreadsheet might not work properly for most of you. If you copy the conditional formatting make sure the row numbers line up otherwise it will be all messed up. Column letter does not matter.
I also moved the profit to the left side and the pair to the right. This makes it easier to sort... you can highlight the entire block for each date, go to the data tab and sort z to a, one simple click.
Luke
Attached File(s)
trader101sys _format.zip
29 KB
|
876 downloads