Calculate the PnL for the current trading day (04/28/2022) given the following tables.

Positions
Position Date	Ticker	Currency	Position
4/27/22	7974 JP Equity	JPY	- 5,900
4/27/22	VOD LN Equity	GBP	- 46,575
4/27/22	AAPL US Equity	USD	1,632
4/27/22	GOOGL US Equity	USD	15,981

Prices
Price Date	Ticker	Currency	Price
4/28/22	7974 JP Equity	JPY	59,910.00
4/28/22	VOD LN Equity	GBP	1.27
4/28/22	AAPL US Equity	USD	163.64
4/28/22	GOOGL US Equity	USD	2,370.45
4/27/22	7974 JP Equity	JPY	61,310.00
4/27/22	VOD LN Equity	GBP	1.26
4/27/22	AAPL US Equity	USD	156.57
4/27/22	GOOGL US Equity	USD	2,285.89

Trade Date	Ticker	Quantity	Price	Currency
4/28/22	7974 JP Equity	200	60500	JPY
4/28/22	7974 JP Equity	-100	60480	JPY
4/28/22	7974 JP Equity	100	60490	JPY
4/28/22	7974 JP Equity	200	60500	JPY
4/28/22	7974 JP Equity	200	60520	JPY
4/28/22	7974 JP Equity	100	60500	JPY
4/28/22	7974 JP Equity	-100	60450	JPY
4/28/22	7974 JP Equity	100	60320	JPY
4/28/22	7974 JP Equity	-100	60300	JPY
4/28/22	VOD LN Equity	2500	1.2604	GBP
4/28/22	VOD LN Equity	-2500	1.2612	GBP
4/28/22	VOD LN Equity	-1016	1.2613	GBP
4/28/22	VOD LN Equity	5000	1.2616	GBP
4/28/22	AAPL US Equity	10	159.31	USD
4/28/22	AAPL US Equity	-100	159.31	USD
4/28/22	GOOGL US Equity	2	2330	USD
4/28/22	GOOGL US Equity	4	2330	USD
4/28/22	GOOGL US Equity	1	2330	USD
4/28/22	GOOGL US Equity	-1	2329.23	USD
4/28/22	GOOGL US Equity	-2	2329.56	USD
4/28/22	GOOGL US Equity	72	2330.05	USD

I would like to do so using python but excel also works too,