Hello - I am writing a loop to copy and paste data from a matrix into a historical time sereis for a backtesting model. The loop works correctly yet the Bloomberg API links to do not refresh. Therefore, the loop continues to copy and paste stale data. I tried to delay the loop but that does not work either. Below is a screen shot of the code. Plus, the loop is very slow so any thoughts about how to speed it up are greatly appreciated. 

Please Login or Register  to view this content.