For stock trade profile, calculate the new positions and add new stock to the new row

Hi my friends! I need some help on the attached Excel file . Please give me a hand if you don't mind.
This excel is for stock trading position record. I would like to automatically add (by using VBA I guess) the new trade position to stocks I have bought (like the first five trades on AAPL &BABA on the "NEW TRADE" and add the trade on a new row if I have no existing position on the stock (like the sixth trade on AMZN on the sheet "NEW TRADE"). Pleas forgive me if what Im saying is confusing Since I am not a English native speaker.