I have 2 Sets of Similar Data containing Market Trades in Governement Securities. Sample attached.
1 set is the Data Universe which contains following columns of Data Security Code called ISIN which is unique code for each security, Trade Date,Trade Time, Face Value , Price, Yield, Trade Category
Another Set is Identical Data. But only my Trades.
What I want is to match the Trades from Universe Table and in same security as my Trade, with same Face Value which is nearest in date and time to my Trade?
I want that just by pasting Universe Data and My Data in 2 tables the Matching happens in another table. Both Using Power Query and Without it?
Thanks for the help in advance
1 post • Page 1 of 1
- (744.74 KiB) Downloaded 13 times
Who is online
Users browsing this forum: No registered users and 2 guests