$VIX 15 min volume into excel

[WilliamV]

I'm trying to extract $VIX 15 min volume into excel and have the following formula in excel : =eSignal|EFS!'Volume$VIX15'.

It's coming up #Name?. Help is appreciated.

Try to search for previous questions on the subject, but didn't find what the correct formula to use. Can I use winros instead of efs?

[ACM]

Re: $VIX 15 min volume into excel

WilliamV
That is probably due to the fact that you have a special character (ie $) in the identifier
You cannot have any spaces or special characters in the identifier. For a code example of how to parse out spaces and special characters from the symbol you may want to see this thread which explains in detail the required routine
Alex

Originally posted by WilliamV
I'm trying to extract $VIX 15 min volume into excel and have the following formula in excel : =eSignal|EFS!'Volume$VIX15'.

It's coming up #Name?. Help is appreciated.

Try to search for previous questions on the subject, but didn't find what the correct formula to use. Can I use winros instead of efs?