Hi, I am trying to build a database to then export into excel with economic variables of different countries. I have certain tickers in an excel file in column A, for simplicity, let's assume these: aTWWOGDPR, aCNWOGDPR, aJPWOGDPR.
I would like to create a database where I extract the values in Column A, Country in column B, Year in column C, month in column D. In a monthly way for Sheet 1, and in a Quarterly way in Sheet 2 (JFM, AMJ, JAS, OND).
I did make a code for future prices but it is not working well when I switch to the economic variables. I can share this if of any help, though is quite big, not the most efficient code. Any help or idea please?