In finance & banking transactions, The interest rate is used in the name of many securities & transactions...If you have this data in excel sheet , then you can filter out the interest rate in separate column using excel formulas . HERE IS HOW
You will have to use MID & FIND function to extract the % and TRIM function to remove the spaces.
Can you extract the date from these securities ?
If yes, please post in the comments.