excel read in and match
Posted: Tue Feb 03, 2015 10:44 am
Hi folks,
Simple question I think but it is baffling me as there are lots of import commands. I have an eviews file with many pages in it and I would like to update the file with new data I have in Excel. To create the model I used code to readin lots of data and give it a range of attributes. When I try and import the updated data it creates new series rather than updating the existing ones. I hope that makes sense! I have attached the Excel and the Eviews of one of the sheets as an example. Basically I need code that can update the eviews variables with the new data in Excel (I have about 30 of these sheets so I will loop it all through once I can master doing it for one)
Thanks in advance
NG
Simple question I think but it is baffling me as there are lots of import commands. I have an eviews file with many pages in it and I would like to update the file with new data I have in Excel. To create the model I used code to readin lots of data and give it a range of attributes. When I try and import the updated data it creates new series rather than updating the existing ones. I hope that makes sense! I have attached the Excel and the Eviews of one of the sheets as an example. Basically I need code that can update the eviews variables with the new data in Excel (I have about 30 of these sheets so I will loop it all through once I can master doing it for one)
Thanks in advance
NG