So that's what I'd like to add..
I know that generally, adding a cell between B and C may completely have an impact on the code,
I'd like to add a column between B and C in order to add the beginning date of the stocks (referent stocks EXCLUDED)
Moreover, can you take a small look at my first macro getquotes()
(the one that gets the data from bloomberg..) in order to not having to put the referent stock under the "stocks" column A but just under "referent"
Finally you'll see a new worksheet called sheet2 which is a database of stocks that can grow (adding new lines each time I have new data)
Is it possible just to generate on a new worksheet a chart with the names of the stocks that are under the stocks "column" (referent stocks EXCLUDED AGAIN) with the data (sort of VLOOKUP or HLOOKUP)?