-
Nieuws Functie Filter
Ik probeer nog steeds een werkende functie te krijgen die het nieuws uit mijn EA filtert. Ik heb geprobeerd de FFCAL te gebruiken, maar realiseerde me dat ik niet wil vertrouwen op een website die voor mij klaar staat om te werken. dus ik probeerde toen met behulp van een CSV-bestand ... Maar ik heb een paar problemen. hier is mijn code ....
Het doel hier is om ...
1. Stel DisableTrading = true en Newstime = true 30 minuten voorafgaand aan de aankondiging in en houd ze waar tot 30 minuten na de aankondiging.
2. Dood mijn open posities 10 min voorafgaand aan de aankondiging.
PHP Code: <code><span style=???color: #000000???> <span style=???color: #0000BB???>
</span><span style=???color: #FF8000???>//Externalparameters================================
</span><span style=???color: #0000BB???>externstringS3</span><span style=???color: #007700???>=</span><span style=???color: #DD0000???>???====NEWSSETTINGS====???</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilterNews</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;</span><span style=???color: #FF8000???>//Settofalsefortesting
</span><span style=???color: #0000BB???>externintMinsPrior</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>30</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externintMinsPost</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>30</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externintMinsKill</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>10</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externstringFileName</span><span style=???color: #007700???>=</span><span style=???color: #DD0000???>???News.csv???</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_High</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_Medium</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_Low</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>false</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_USD</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_CAD</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_EUR</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_GBP</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_CHF</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_JPY</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_AUD</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>externboolFilter_NZD</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #FF8000???>//Internalparameters================================
</span><span style=???color: #0000BB???>boolNewsTime</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>false</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>inthandle</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>inteCount</span><span style=???color: #007700???>;
static</span><span style=???color: #0000BB???>datetimeeTime</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>9999</span><span style=???color: #007700???>#93;;
static</span><span style=???color: #0000BB???>inteImpact</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>9999</span><span style=???color: #007700???>#93;;
static</span><span style=???color: #0000BB???>stringeCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>9999</span><span style=???color: #007700???>#93;;
static</span><span style=???color: #0000BB???>stringeText1</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>9999</span><span style=???color: #007700???>#93;;
</span><span style=???color: #FF8000???>//Thefunction=====================================
//=====================================NEWSTIME===== ================================================== ======
</span><span style=???color: #0000BB???>voideNewsTime</span><span style=???color: #007700???>(){
</span><span style=???color: #0000BB???>intiHoursCache</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>2</span><span style=???color: #007700???>;
static</span><span style=???color: #0000BB???>datetimedtLastRead</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>0</span><span style=???color: #007700???>;</span><span style=???color: #FF8000???>//vartoholdlastfilereadtime
</span><span style=???color: #007700???>if(</span><span style=???color: #0000BB???>dtLastRead</span><span style=???color: #007700???> </span><span style=???color: #0000BB???>iHoursCache</span><span style=???color: #007700???>*</span><span style=???color: #0000BB???>60</span><span style=???color: #007700???>lt;</span><span style=???color: #0000BB???>TimeCurrent</span><span style=???color: #007700???>()){
</span><span style=???color: #0000BB???>handle</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>FileOpen</span><span style=???color: #007700???>(</span><span style=???color: #0000BB???>FileName</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>FILE_CSV</span><span style=???color: #007700???>|</span><span style=???color: #0000BB???>FILE_READ</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>';'</span><span style=???color: #007700???>);</span><span style=???color: #FF8000???>//OpenNEWS.CSV
</span><span style=???color: #007700???>if(</span><span style=???color: #0000BB???>handle</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>0</span><span style=???color: #007700???>){</span><span style=???color: #0000BB???>Comment</span><span style=???color: #007700???>(</span><span style=???color: #DD0000???>???File???</span><span style=???color: #007700???> </span><span style=???color: #0000BB???>FileName</span><span style=???color: #007700???> </span><span style=???color: #DD0000???>???notfound.???</span><span style=???color: #007700???>);}
for(</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>0</span><span style=???color: #007700???>;!</span><span style=???color: #0000BB???>FileIsEnding</span><span style=???color: #007700???>(</span><span style=???color: #0000BB???>handle</span><span style=???color: #007700???>);</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???> ){</span><span style=???color: #FF8000???>//ReadfromNEWS.CSV;onelineperevent
</span><span style=???color: #0000BB???>eTime</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;=</span><span style=???color: #0000BB???>StrToTime</span><span style=???color: #007700???>(</span><span style=???color: #0000BB???>FileReadString</span><span style=???color: #007700???>(</span><span style=???color: #0000BB???>handle</span><span style=???color: #007700???>));</span><span style=???color: #FF8000???>//Eventdate/time
</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;=</span><span style=???color: #0000BB???>FileReadString</span><span style=???color: #007700???>(</span><span style=???color: #0000BB???>handle</span><span style=???color: #007700???>);</span><span style=???color: #FF8000???>//Currency
</span><span style=???color: #0000BB???>eImpact</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;=</span><span style=???color: #0000BB???>StrToInteger</span><span style=???color: #007700???>(</span><span style=???color: #0000BB???>FileReadString</span><span style=???color: #007700???>(</span><span style=???color: #0000BB???>handle</span><span style=???color: #007700???>));</span><span style=???color: #FF8000???>//Impact:1=low;2=medium;3=High
</span><span style=???color: #0000BB???>eText1</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;=</span><span style=???color: #0000BB???>FileReadString</span><span style=???color: #007700???>(</span><span style=???color: #0000BB???>handle</span><span style=???color: #007700???>);</span><span style=???color: #FF8000???>//Description
</span><span style=???color: #007700???>}
}
}
</span><span style=???color: #FF8000???>//Andthelogic======================================= ====
//inthestart...
//Updatethenewsarrays
</span><span style=???color: #0000BB???>eNewsTime</span><span style=???color: #007700???>();
if((</span><span style=???color: #0000BB???>eImpact</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #0000BB???>1</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_Low</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>TRUE</span><span style=???color: #007700???>)||(</span><span style=???color: #0000BB???>eImpact</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #0000BB???>2</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_Medium</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>TRUE</span><span style=???color: #007700???>)||(</span><span style=???color: #0000BB???>eImpact</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_High</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>TRUE</span><span style=???color: #007700???>)){
if((</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_USD</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>)||
(</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_CAD</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>)||
(</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_EUR</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>)||
(</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_GBP</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>)||
(</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #DD0000???>???CHF???</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_CHF</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>)||
(</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_JPY</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>)||
(</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #DD0000???>???AUD???</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_AUD</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>)||
(</span><span style=???color: #0000BB???>eCurrency</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;==</span><span style=???color: #DD0000???>???NZD???</span><span style=???color: #007700???></span><span style=???color: #0000BB???>Filter_NZD</span><span style=???color: #007700???>==</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>)){
</span><span style=???color: #FF8000???>//TheSkipNewsFunction
</span><span style=???color: #007700???>if(</span><span style=???color: #0000BB???>TimeCurrent</span><span style=???color: #007700???>()gt;=</span><span style=???color: #0000BB???>eTime</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;-(</span><span style=???color: #0000BB???>MinsPrior</span><span style=???color: #007700???>*</span><span style=???color: #0000BB???>60</span><span style=???color: #007700???>)){
</span><span style=???color: #0000BB???>DisableTrading</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>NewsTime</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
Print(</span><span style=???color: #0000BB???>eText1</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;);
}
if(</span><span style=???color: #0000BB???>TimeCurrent</span><span style=???color: #007700???>()lt;=</span><span style=???color: #0000BB???>eTime</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93; (</span><span style=???color: #0000BB???>MinsPost</span><span style=???color: #007700???>*</span><span style=???color: #0000BB???>60</span><span style=???color: #007700???>)){
</span><span style=???color: #0000BB???>DisableTrading</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>NewsTime</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
}
if(</span><span style=???color: #0000BB???>TimeCurrent</span><span style=???color: #007700???>()gt;=</span><span style=???color: #0000BB???>eTime</span><span style=???color: #007700???>#91;</span><span style=???color: #0000BB???>eCount</span><span style=???color: #007700???>#93;-(</span><span style=???color: #0000BB???>MinsKill</span><span style=???color: #007700???>*</span><span style=???color: #0000BB???>60</span><span style=???color: #007700???>)){
</span><span style=???color: #0000BB???>DisableTrading</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>NewsTime</span><span style=???color: #007700???>=</span><span style=???color: #0000BB???>true</span><span style=???color: #007700???>;
</span><span style=???color: #0000BB???>KillLongs</span><span style=???color: #007700???>();
</span><span style=???color: #0000BB???>KillShorts</span><span style=???color: #007700???>();
}
}
}
</span><span style=???color: #0000BB???></span> </span> </code> And this is what the News.csv file looks like
PHP Code: <code><span style=???color: #000000???> <span style=???color: #0000BB???>
</span><span style=???color: #DD0000???>???2007.04.1205:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???Q4GDPq/q???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.90</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.60</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1207:45???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???ECBMonetaryPolicyDecision???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3.75</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>3.75</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1208:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???WeeklyJoblessClaims???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???320.0k???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???321.0k???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1305:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryIndustrialProductiony/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>4.20</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>3.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1305:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryIndustrialProductionm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.40</span><span style=???color: #007700???>%,-</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1308:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryTradeBalance???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???C$6.0bln???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???C$6.35bln???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1308:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchPPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???n/f???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.50</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1308:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchcorePPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.40</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1308:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchPPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.70</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>1.30</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1308:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryTradeDeficit???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???$-60.0bln???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???$-59.12bln???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1310:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilUniversityofMichiganSentiment?? ?</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>87.5</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>88.4</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1600:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryIndustrialProductionrevisedm/m???</span><span style=???color: #007700???>,-</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,-</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1600:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryCapacityUtilization???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???n/f???</span><span style=???color: #007700???>,-</span><span style=???color: #0000BB???>2.90</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1602:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GermanyMarchCPIfinalm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.30</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.40</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1602:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GermanyMarchHICPfinaly/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.10</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>1.90</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1602:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GermanyMarchHICPfinalm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.30</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.50</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1602:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GermanyMarchCPIfinaly/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>1.90</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>1.60</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1604:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchcorePPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.70</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>2.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1604:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchcorePPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.50</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1605:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EurozoneMarchHICPfinaly/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>1.90</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>1.80</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1605:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EurozoneMarchHICPfinalm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.60</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.30</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1608:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchRetailSales???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.60</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.10</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1608:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilNYFedManufacturingSurvey???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>7.5</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>1.85</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1608:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchRetailSalesexclAutos???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.90</span><span style=???color: #007700???>%,-</span><span style=???color: #0000BB???>0.10</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1609:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryNetTreasuryInt'lCapitalFlows (TICS)???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???$76.0bln???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???$74.6bln???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1610:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryBusinessInventories???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.30</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1614:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilNAHBSurvey(Housing)???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>35</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>36</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1701:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchConfidenceIndex???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???n/f???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>48.4</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1704:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchRPI-Xy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3.70</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>3.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1704:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchRPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>4.60</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>4.60</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1704:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchCPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.80</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>2.80</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1704:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchRPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.40</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1704:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchCPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.30</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.40</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1705:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EurozoneFebruaryTradeBalance???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???-5.0blneuros???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???-7.8blneuros???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1705:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GermanyAprilZEWSurveyIndex???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>10</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>5.8</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1705:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GermanyAprilZEWSurveyCurrentConditio ns???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>69</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>69.2</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1708:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryManufacturingShipments???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.50</span><span style=???color: #007700???>%,-</span><span style=???color: #0000BB???>2.10</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1708:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchHousingStarts???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???1.495mlnunits???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???1.525mlnunits???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1708:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchcoreCPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.60</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>2.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1708:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchcoreCPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1708:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchCPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.80</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>2.40</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1708:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchCPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.60</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.40</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1708:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchBuildingPermits???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???1.51mlnunits???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???1.532mlnunits???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1709:15???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchIndustrialProduction???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.10</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>1.00</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1709:15???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchCapacityUtilization???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>81.90</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>82.00</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1801:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryLeadingIndiors???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???n/f???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>30</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1801:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryCoincidentIndior???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???n/f???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>16.7</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1804:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryILOUnemploymentRate???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>5.50</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>5.50</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1804:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchClaimantCount???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???-5.0k???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???-3.8k???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1804:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilMPCMinutes???</span><span style=???color: #007700???>,,,
</span><span style=???color: #DD0000???>???2007.04.1804:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryAverageEarnings3-mth???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>4.30</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>4.20</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1819:50???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryTertiaryIndex???</span><span style=???color: #007700???>,-</span><span style=???color: #0000BB???>0.40</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>1.60</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1902:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GermanyMarchPPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.70</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>2.80</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1902:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GermanyMarchPPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.40</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.30</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1907:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchcoreCPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.30</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>2.40</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1907:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchcoreCPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.50</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1907:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchCPIy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.20</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>2.00</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1907:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchCPIm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.70</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1908:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryWholesaleTradem/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.10</span><span style=???color: #007700???>%,-</span><span style=???color: #0000BB???>0.50</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1908:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???WeeklyJoblessClaims???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???323k???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???342k???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1910:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchLeadingEconomicIndiors???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.10</span><span style=???color: #007700???>%,-</span><span style=???color: #0000BB???>0.50</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.1912:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilPhiladelphiaFedSurvey???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.2</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.1919:50???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryAll-IndustrySurvey???</span><span style=???color: #007700???>,-</span><span style=???color: #0000BB???>0.30</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2004:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchRetailSalesm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.50</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>1.40</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2008:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryRetailSalesex-autosm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.30</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2008:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryRetailSalesm/m???</span><span style=???color: #007700???>,-</span><span style=???color: #0000BB???>0.10</span><span style=???color: #007700???>%,-</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2404:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryEurozoneCurrentAccountBalanc e???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???2.0blneuros???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???-6.0blneuros???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2405:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryIndustrialOrdersm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>1.10</span><span style=???color: #007700???>%,-</span><span style=???color: #0000BB???>0.20</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2405:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???FebruaryEurozoneIndustrialOrdersy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>7.80</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>12.00</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2408:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchLeadingIndior???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.50</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2409:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???CAD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???BankofCanadaMonetaryPolicyDecision?? ?</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>4.25</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>4.25</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2410:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilConsumerConfidence???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>105</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>107.2</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2410:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilExistingHomeSales???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???6.45mlnunits???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???6.69mlnunits???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2419:50???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchTradeBalance???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???n/f???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???979.6blnyen???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2504:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilGermanyIFOIndex???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>108</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>107.7</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2504:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???EUR???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilGermanyIFOCurrentConditions???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>112.6</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>112.4</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2504:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???Q1GDPy/y???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.80</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>3.00</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2504:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???GBP???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???Q1GDPq/q???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>0.60</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2508:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchDurableGoodsOrders???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>2.50</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>1.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2510:00???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchNewHomeSales???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???888kunits???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???848kunits???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2608:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???USD???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???WeeklyJoblessClaims???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???330k???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???339k???</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2619:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchIndustrialProductionm/m???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>1.00</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>0.70</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2619:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???MarchUnemploymentRate???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>4.00</span><span style=???color: #007700???>%,</span><span style=???color: #0000BB???>4.00</span><span style=???color: #007700???>%,
</span><span style=???color: #DD0000???>???2007.04.2619:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>3</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???AprilManufacturingPMI???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???n/f???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???>52.5</span><span style=???color: #007700???>,
</span><span style=???color: #DD0000???>???2007.04.2619:30???</span><span style=???color: #007700???>,</span><span style=???color: #DD0000???>???JPY???</span><span style=???color: #007700???>,</span><span style=???color: #0000BB???
-
OK ik realiseerde me dat ik handle = FileOpen (FileName, FILE_CSV | FILE_READ, ';') gebruikte; toen mijn deliminator is, heb ik het veranderd en krijg ik nog steeds hetzelfde ... GRR handle = FileOpen (FileName, FILE_CSV | FILE_READ, ',');
-
Kurka, dit is slechts een gok, maar wordt het probleem veroorzaakt door de komma aan het einde van elke regel in je news.csv-bestand? De code in uw FOR-lus maakt slechts 4 items (tijd, valuta, impact, tekst) per regel mogelijk, maar de komma zou aan het einde van elke regel een (leeg) 5e item kunnen maken. Veel succes David