Match the nearest Date and Time for same security using power query

deepsi1
Posts: 1
Joined: Sat Jul 18, 2020 6:58 pm

Match the nearest Date and Time for same security using power query

Postby deepsi1 » Sat Jul 18, 2020 7:03 pm

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
 
Attachments
Archival_NDSOM_13-Jul-2020_17-Jul-2020.xlsx
(744.74 KiB) Downloaded 10 times

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest

cron