Hi All,
I have a data set of a few weeks which includes account transactions per date, and also the corresponding premium/discount on the day. Is there a way i can use excel to identify accounts which have recorded and traded when the premium/discount is better?
I have set column J of sheet 1 to be the premium/discount per date. Then i have the movement in units per date also given on the sheet. Is there a way to identify and trends or correlations between premium and account movement?
Thank you all kindly for any assistance.
