Hello,
i´m using bet angel prof with excel template and want to filter markets, which are on TOP 5 of increasing matched volume.
Market A: 100.000
Market B: 50.000
Market C: 20.000
5 seconds later:
Market A: 105.000
Market B: 65.000
Market C: 21.000
Now i want following sorting:
Market B: + 15.000
Market A: + 5.000
Market C + 1.000
I can sort markets in excel but how to filter to additional volume ? Can you give advice in this case ?
Thank you very much.
Regards,
Frank
Increasing Volume in Excel
Is this info "live" ie, changing every ## seconds? or is it data you are entering manually?
The first instance, you'll need to use vba to keep track of the changing column and enter the formula automatically, second instance, all you need to do is add another column, subtract current vol from previous vol and sort by the difference, highest to lowest.
The first instance, you'll need to use vba to keep track of the changing column and enter the formula automatically, second instance, all you need to do is add another column, subtract current vol from previous vol and sort by the difference, highest to lowest.