<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[Forex Software — Problem with Imported Data]]></title>
		<link>https://forexsb.com/forum/topic/707/problem-with-imported-data/</link>
		<atom:link href="https://forexsb.com/forum/feed/rss/topic/707/" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Problem with Imported Data.]]></description>
		<lastBuildDate>Wed, 04 Mar 2009 12:18:21 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Problem with Imported Data]]></title>
			<link>https://forexsb.com/forum/post/2210/#p2210</link>
			<description><![CDATA[<p>I tested this link: <a href="http://www.crowestudios.com/transfers/currency_history.htm">http://www.crowestudios.com/transfers/c … istory.htm</a> It leads to: InterbankFX Currency Pair Data Downlaods</p><p>There are AUDUSD and EURGBP data there (from 1Minute to 1Month period). The files are in CSV format. To download the file I used right-click and Save Link As… (Firefox).</p><p>The file name I chose EURGBPm1440.csv. First I renamed the file to EURGBP1440.csv.</p><p>The file format was as follow:</p><p>1979.05.28,00:00,0.49690,0.49700,0.49670,0.49690,7<br />1979.05.29,00:00,0.49590,0.49610,0.49550,0.49590,13<br />1979.05.30,00:00,0.49590,0.49590,0.49590,0.49590,1<br />1979.05.31,00:00,0.49640,0.49790,0.49490,0.49640,61<br />1979.06.01,00:00,0.49220,0.49270,0.49170,0.49220,21</p><p>The file format looks acceptable to Forex Strategy Builder.</p><p>Next I added EURGBP symbol to Forex Strategy Builder by using Menu Market -&gt; Edit Instruments dialog:</p><p><a href="http://www.postimage.org/image.php?v=PqNfhFA"><span class="postimg"><img src="http://www.postimage.org/PqNfhFA.jpg" alt="http://www.postimage.org/PqNfhFA.jpg" /></span></a></p><p>1. Instrument symbol – in this case EURGBP;<br />2. Type of the instrument: Forex;<br />3. Confirming by pressing “Add” button;<br />4. I left this field as it was: 4 digits;<br />5. Lot size – it depends on your account;<br />6. Spread – it depends on the broker but 4 is OK for now.<br />7. Swap long and Swap short 1 and -1 are OK;<br />8. Account Exchange Rate – it has to be set here. My account is in USD, but the trading result for this couple is in GBP. I set 0.86 here. Forex Strategy Builder will convert GBP to USD using this rate.<br />9. “Accept” button confirms the changes.</p><p>It should be OK now. I select EURGBP but I received this error message:</p><p><a href="http://www.postimage.org/image.php?v=gx1FwazJ"><span class="postimg"><img src="http://www.postimage.org/gx1FwazJ.jpg" alt="http://www.postimage.org/gx1FwazJ.jpg" /></span></a></p><p>Data defective till bar 2577!</p><p>So I opened the data file in my favorite text editor Notepad++:</p><p>1989.06.16,00:00,0.64500,0.64870,0.63990,0.64500,177<br />1989.06.19,00:00,0.64290,0.64450,0.63990,0.64290,93<br />1989.06.20,00:00,0.64070,0.64220,0.63970,0.64070,51<br />1989.06.21,00:00,0.63700,0.63700,0.63550,0.63700,31<br />1989.06.22,00:00,0.64650,0.64990,0.64370,0.64650,125<br />1989.06.23,00:00,0.64420,0.64480,0.64310,0.64420,35</p><p>The error comes from the fact that Price Open = Price Close. This can lead to errors in calculation of some technical indicators, so I cut the data till bar 2577.</p><p>Now everything is OK.</p><p><a href="http://www.postimage.org/image.php?v=aVLKRQi"><span class="postimg"><img src="http://www.postimage.org/aVLKRQi.jpg" alt="http://www.postimage.org/aVLKRQi.jpg" /></span></a></p><p>If you don’t want to modify the data file, you can select the option “Cut Off Bad Data” from the Market Menu. If you do so Forex Strategy builder will load the correct data only. Another option is to use “Data Horizon” to remove older (defective) data.</p>]]></description>
			<author><![CDATA[null@example.com (Popov)]]></author>
			<pubDate>Wed, 04 Mar 2009 12:18:21 +0000</pubDate>
			<guid>https://forexsb.com/forum/post/2210/#p2210</guid>
		</item>
		<item>
			<title><![CDATA[Re: Problem with Imported Data]]></title>
			<link>https://forexsb.com/forum/post/1849/#p1849</link>
			<description><![CDATA[<p>Here are a few rows of AUDUSD 30 minute data from InterbankFX:</p><p>&quot;2007.03.20&nbsp; &nbsp; 10:30&nbsp; &nbsp; 0.7996&nbsp; &nbsp; 0.8002&nbsp; &nbsp; 0.7996&nbsp; &nbsp; 0.8002&nbsp; &nbsp; 61&quot;<br />&quot;2008.07.21&nbsp; &nbsp; 1:30&nbsp; &nbsp; 0.9729&nbsp; &nbsp; 0.9743&nbsp; &nbsp; 0.9728&nbsp; &nbsp; 0.9742&nbsp; &nbsp; 112&quot;<br />&quot;2008.07.21&nbsp; &nbsp; 2:00&nbsp; &nbsp; 0.9741&nbsp; &nbsp; 0.9753&nbsp; &nbsp; 0.9741&nbsp; &nbsp; 0.9744&nbsp; &nbsp; 164&quot;<br />&quot;2008.07.21&nbsp; &nbsp; 2:30&nbsp; &nbsp; 0.9743&nbsp; &nbsp; 0.975&nbsp; &nbsp; 0.9741&nbsp; &nbsp; 0.9747&nbsp; &nbsp; 87&quot;<br />&quot;2008.07.21&nbsp; &nbsp; 3:00&nbsp; &nbsp; 0.9748&nbsp; &nbsp; 0.9754&nbsp; &nbsp; 0.9745&nbsp; &nbsp; 0.9753&nbsp; &nbsp; 84&quot;<br />&quot;2008.07.21&nbsp; &nbsp; 3:30&nbsp; &nbsp; 0.9754&nbsp; &nbsp; 0.9757&nbsp; &nbsp; 0.9747&nbsp; &nbsp; 0.9747&nbsp; &nbsp; 52&quot;<br />&quot;2008.07.21&nbsp; &nbsp; 4:00&nbsp; &nbsp; 0.9748&nbsp; &nbsp; 0.9754&nbsp; &nbsp; 0.9744&nbsp; &nbsp; 0.9753&nbsp; &nbsp; 96&quot;<br />&quot;2008.07.21&nbsp; &nbsp; 4:30&nbsp; &nbsp; 0.9754&nbsp; &nbsp; 0.9755&nbsp; &nbsp; 0.9751&nbsp; &nbsp; 0.9753&nbsp; &nbsp; 62&quot;<br />&quot;2008.07.21&nbsp; &nbsp; 5:00&nbsp; &nbsp; 0.9754&nbsp; &nbsp; 0.9754&nbsp; &nbsp; 0.9744&nbsp; &nbsp; 0.9749&nbsp; &nbsp; 66&quot;</p><br /><p>I have uploaded copies of the files, and have put up a temporary Web page with links to them if you want to download copies of the actual files to check them out.</p><p>http://www.crowestudios.com/transfers/currency_history.htm</p><p>Max</p>]]></description>
			<author><![CDATA[null@example.com (Max)]]></author>
			<pubDate>Mon, 12 Jan 2009 01:43:38 +0000</pubDate>
			<guid>https://forexsb.com/forum/post/1849/#p1849</guid>
		</item>
		<item>
			<title><![CDATA[Re: Problem with Imported Data]]></title>
			<link>https://forexsb.com/forum/post/1844/#p1844</link>
			<description><![CDATA[<p>The problem is not the column separator. It can be comma, tab, space, semicolon...</p><p>Forex Strategy Builder works fine with MT data. <br />Can you post several rows from the file here.</p>]]></description>
			<author><![CDATA[null@example.com (Popov)]]></author>
			<pubDate>Sun, 11 Jan 2009 07:34:14 +0000</pubDate>
			<guid>https://forexsb.com/forum/post/1844/#p1844</guid>
		</item>
		<item>
			<title><![CDATA[Problem with Imported Data]]></title>
			<link>https://forexsb.com/forum/post/1843/#p1843</link>
			<description><![CDATA[<p>Hello,</p><p>I Exported AUDUSD and EURGBP data from InterbankFX MetaTrader4 as a CSV, but FSB wouldn&#039;t accept it. To find out why, I imported the saved file into Excel and noted that it was comma separated, but that the instructions on this site say that it should be tab separated. So, I saved it out as a tab separated file with a .csv filename extension. This doesn&#039;t work either.</p><p>Can anyone tell me what I am doing wrong?</p><p>Thanks,</p><p>Max</p>]]></description>
			<author><![CDATA[null@example.com (Max)]]></author>
			<pubDate>Sun, 11 Jan 2009 03:17:36 +0000</pubDate>
			<guid>https://forexsb.com/forum/post/1843/#p1843</guid>
		</item>
	</channel>
</rss>
