Hi, I'm sure I can't be the first, so:
- I want to import news from FF into Excel on a regular, automated basis.
- Web queries work fine, as FF data is all nicely tabled (which is why FF data is so good), and it imports like a dream
... but I don't know:
- how to pass a variable through the web query so that it updates with the current date
- what the format of FF queries are. I can't figure it out. Take a look at the news from last week and next. I get the month and year, but what's week (see below)?
Any help in cracking either problem would be much appreciated...
w/c 6/9
http://www.forexfactory.com/calendar...th=9&year=2009
w/c 13/9
http://www.forexfactory.com/calendar...th=9&year=2009
- I want to import news from FF into Excel on a regular, automated basis.
- Web queries work fine, as FF data is all nicely tabled (which is why FF data is so good), and it imports like a dream
... but I don't know:
- how to pass a variable through the web query so that it updates with the current date
- what the format of FF queries are. I can't figure it out. Take a look at the news from last week and next. I get the month and year, but what's week (see below)?
Any help in cracking either problem would be much appreciated...
w/c 6/9
http://www.forexfactory.com/calendar...th=9&year=2009
w/c 13/9
http://www.forexfactory.com/calendar...th=9&year=2009