I see thanks. The code works but I not sure what data it is pullling in. My data are based on links from Bloomberg and the data pasted from the code leaves an error. Would you prefer I emailed you a copy of the sheet?