Swapping topic content directly on Organizers' worksheets

[andrea guerriero]

My intention is starting from a workbook with many worksheets I would like to create new  workbooks where the worksheets are obtained swapping assets from the orginal one with date ranges adjusted.

If one perform the operation manually is quite straightforward.

On the contrary when trying to prtfrom the same operation on datalab I have not progressed from doing the operation signal by signal (I'm attaching the relevant createSwaapedWorksheet.ipynb). This example insert into the same worksheet new content so it is only in any case a partial step.  However if one have to swap tens of assets for hundreds of signals per asset this approach does not seem to be viable.

 

I've seen that a similar problem has be tackled here 

 

where the signals are taken directly into to the worksheet, but they seem to be taken again one by one.

 

I've also tried to swap signals. So I've taken some signals 

 

 

and then I swapped them

 

Now I'm stuck because I do not know how to use them. Also because the organizer will have manu worksheets and many relevant  workbenches and I do not know how to use the dataframe with wwapping relation to swap my topic content.

 

Does anyone has already tackled this issue? Is solvable?

 

thanks,

Andrea 

createSwaapedWorksheet.ipynb