Log In
Register
Home
New Member
July 18, 2020
Offline
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
July 16, 2010
Offline
Hi Deep,
Welcome to our forum! You only attached one file, so it's a bit difficult to help specifically, but this is similar to replicating an approximate match merge in Power Query.
Obviously you'll have multiple columns that you want to match in the merge dialog box.
I hope that points you in the right direction.
Mynda
New Member
July 18, 2020
Offline
Hi Mynda,
I attached only one file as this is the universe table and My Data will be a subset of this data. So we could actually take any one line from this as my Trade and try to match it with the nearest trade in same security for same Face Value. Hope this clarifies
Thanks
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi,
try the file attached.
1 Guest(s)
