Page 1 of 1
second frequency when importing from excel
Posted: Tue Nov 05, 2013 8:28 am
by lomfy
Hello! I'm trying to import secondwise data from an xlsx-file. However, my command doesn't work (it did for monthly data with "@freq m" instead of "@freq s").
import(type=excelxml) "00_intraday" range="Aufzeichnung!A1:BB1000000" colhead=2 namepos=last @freq "s" 11/05/2013 10:04:09
Is @freq "s" wrong? I couldn't find the abbreviation for secondwise....
Thanks!
Wolfgang
Re: second frequency when importing from excel
Posted: Tue Nov 05, 2013 8:28 am
by lomfy
Sorry, I forgot: I'm using Eviews 7.2. The error report reads:
Invalid frequency specification: "s" 11/05/2013 10:04:09 in "IMPORT(TYPE=EXCELXML) "00_INTRADAY" RANGE="AUFZEICHNUNG!A1:BB10000 ...
Re: second frequency when importing from excel
Posted: Tue Nov 05, 2013 9:03 am
by EViews Gareth
Try "Sec" rather than "s"
Re: second frequency when importing from excel
Posted: Tue Nov 05, 2013 9:11 am
by lomfy
Hey Gareth, thanks for the quicky reply - actually I stumbled across "sec" soon after i posted & tried it out straightaway.
import(type=excelxml) "00_intraday" range="Aufzeichnung!A1:BB1000000" colhead=2 namepos=last @freq "Sec" 11/05/2013 10:04:09
However, it still gave me the error message:
Invalid frequency specification: "Sec" 11/05/2013 10:04:09 in "IMPORT(TYPE=EXCELXML) "00_INTRADAY" RANGE="AUFZEICHNUNG!A1:BB100 ...
Any ideas why? Also, I must correct - I'm using 7.1, not 7.2....
Re: second frequency when importing from excel
Posted: Tue Nov 05, 2013 9:27 am
by lomfy
Ok, I got it - should have left out the " " here...sorry for the hassle ;-)