<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[Forex Software — Stocks historical data]]></title>
	<link rel="self" href="https://forexsb.com/forum/feed/atom/topic/725/" />
	<updated>2013-02-02T07:59:07Z</updated>
	<generator>PunBB</generator>
	<id>https://forexsb.com/forum/topic/725/stocks-historical-data/</id>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/18039/#p18039" />
			<content type="html"><![CDATA[<div class="quotebox"><cite>Popov wrote:</cite><blockquote><p>As dan9mar says Yahoo Finance is a good source of data.</p><p>To use it we have to complete several steps:</p><p>1. Open the data file as a spreadsheet;<br />2. Delete the last column (Adj Close)<br />3. Delete the first row (with the column titles);<br />4. Add a new column between the first and the second. Put 00:00 in it. That is the hour column. We have 7 columns now (A-G);&#039;<br />5. Select the price columns (C-F). Pres &quot;Increase Decimal&quot; and after that &quot;Decrease Decimal&quot;. That puts a decimal point to all of the prices.<br />6. Now we need to sort the data rows. The newest bar have to be the bottom one. To do this select all the columns and go to &quot;Data&quot; menu -&gt; &quot;Sort&quot;. Set the options &quot;Sort by Column A&quot;,&nbsp; &quot;Ascending&quot;.&nbsp; Press &quot;OK&quot;.<br />7. Save the file as CSV in your data directory. For example ESIC1440.csv</p><p>That is all. It looks a little&nbsp; bit complicated but these steps are necessary.</p></blockquote></div><p>Iam using a quote downloader there are many in the market it saves lots of efforts from editing data but it needs one step&nbsp; ( to change every stock name ) to fit the criteria required by FSB&nbsp; any solution for this step!!!! </p><p>regards</p>]]></content>
			<author>
				<name><![CDATA[ahmedalhoseny]]></name>
				<uri>https://forexsb.com/forum/user/1512/</uri>
			</author>
			<updated>2013-02-02T07:59:07Z</updated>
			<id>https://forexsb.com/forum/post/18039/#p18039</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/2460/#p2460" />
			<content type="html"><![CDATA[<div class="quotebox"><cite>echernandezr wrote:</cite><blockquote><p>Hello again, i need to know how i can include new currency pairs. Thanks again</p></blockquote></div><p>Use <strong>Market Menu</strong> -&gt; <strong>Edit Instruments</strong></p>]]></content>
			<author>
				<name><![CDATA[Popov]]></name>
				<uri>https://forexsb.com/forum/user/2/</uri>
			</author>
			<updated>2009-05-07T16:55:20Z</updated>
			<id>https://forexsb.com/forum/post/2460/#p2460</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/2459/#p2459" />
			<content type="html"><![CDATA[<p>Hello again, i need to know how i can include new currency pairs. Thanks again</p>]]></content>
			<author>
				<name><![CDATA[echernandezr]]></name>
				<uri>https://forexsb.com/forum/user/1024/</uri>
			</author>
			<updated>2009-05-07T15:52:26Z</updated>
			<id>https://forexsb.com/forum/post/2459/#p2459</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/2458/#p2458" />
			<content type="html"><![CDATA[<p>Hi, my english is very bad, but i need to know how i can include data of my broker FXCM. Thanks</p>]]></content>
			<author>
				<name><![CDATA[echernandezr]]></name>
				<uri>https://forexsb.com/forum/user/1024/</uri>
			</author>
			<updated>2009-05-07T15:24:23Z</updated>
			<id>https://forexsb.com/forum/post/2458/#p2458</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/2376/#p2376" />
			<content type="html"><![CDATA[<p>How can I increase the number of bars in Market statistics? or this is impossible to do, because i wanna see data for 10 years however it shows me only 2 or 3 years back<br />Thanks:/</p>]]></content>
			<author>
				<name><![CDATA[marisha]]></name>
				<uri>https://forexsb.com/forum/user/966/</uri>
			</author>
			<updated>2009-04-07T16:16:10Z</updated>
			<id>https://forexsb.com/forum/post/2376/#p2376</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/1810/#p1810" />
			<content type="html"><![CDATA[<p>I was just about to ask that since I got an error message when I tried to upload the data. However, now it seems everything is finally working.</p>]]></content>
			<author>
				<name><![CDATA[Karl Marx]]></name>
				<uri>https://forexsb.com/forum/user/5/</uri>
			</author>
			<updated>2009-01-05T18:47:04Z</updated>
			<id>https://forexsb.com/forum/post/1810/#p1810</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/1809/#p1809" />
			<content type="html"><![CDATA[<p>As dan9mar says Yahoo Finance is a good source of data.</p><p>To use it we have to complete several steps:</p><p>1. Open the data file as a spreadsheet;<br />2. Delete the last column (Adj Close)<br />3. Delete the first row (with the column titles);<br />4. Add a new column between the first and the second. Put 00:00 in it. That is the hour column. We have 7 columns now (A-G);&#039;<br />5. Select the price columns (C-F). Pres &quot;Increase Decimal&quot; and after that &quot;Decrease Decimal&quot;. That puts a decimal point to all of the prices.<br />6. Now we need to sort the data rows. The newest bar have to be the bottom one. To do this select all the columns and go to &quot;Data&quot; menu -&gt; &quot;Sort&quot;. Set the options &quot;Sort by Column A&quot;,&nbsp; &quot;Ascending&quot;.&nbsp; Press &quot;OK&quot;.<br />7. Save the file as CSV in your data directory. For example ESIC1440.csv</p><p>That is all. It looks a little&nbsp; bit complicated but these steps are necessary.</p>]]></content>
			<author>
				<name><![CDATA[Popov]]></name>
				<uri>https://forexsb.com/forum/user/2/</uri>
			</author>
			<updated>2009-01-05T18:03:53Z</updated>
			<id>https://forexsb.com/forum/post/1809/#p1809</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/1808/#p1808" />
			<content type="html"><![CDATA[<p>Hey thanks a lot! Exactly what I was looking for, unfortunately I&#039;m newbie in stock trading via Metatrader so won&#039;t be much of a help on that topic.</p>]]></content>
			<author>
				<name><![CDATA[Karl Marx]]></name>
				<uri>https://forexsb.com/forum/user/5/</uri>
			</author>
			<updated>2009-01-05T17:16:22Z</updated>
			<id>https://forexsb.com/forum/post/1808/#p1808</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/1807/#p1807" />
			<content type="html"><![CDATA[<p>Yahoo Finance has excellent stock &amp; options downloadable data in .csv format here &gt;&gt;&gt;</p><p>http://finance.yahoo.com/q/hp?s=ESIC</p><p>Just click at the bottom to download the stock (ESIC in this example) data to your spreadsheet.</p><p>You may also wish to download more than the normal daily Time, Open,Hi, Lo,Close, Volume by using Yahoo tags found here&nbsp; &gt;&gt;&gt;&nbsp; http://www.gummy-stuff.org/Yahoo-data.htm</p><p>BTW, do you know how to use Metatrader 4 to auto trade stocks?</p><p>Hope this helps.</p>]]></content>
			<author>
				<name><![CDATA[dan9mar]]></name>
				<uri>https://forexsb.com/forum/user/144/</uri>
			</author>
			<updated>2009-01-05T16:25:42Z</updated>
			<id>https://forexsb.com/forum/post/1807/#p1807</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/1806/#p1806" />
			<content type="html"><![CDATA[<p>Ops, that&#039;s what I ment - csv instead of xml. But what I was interested in was to find an internet source for such data for shares and indices. I have no problem finding forex quotes.</p>]]></content>
			<author>
				<name><![CDATA[Karl Marx]]></name>
				<uri>https://forexsb.com/forum/user/5/</uri>
			</author>
			<updated>2009-01-05T15:47:51Z</updated>
			<id>https://forexsb.com/forum/post/1806/#p1806</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/1805/#p1805" />
			<content type="html"><![CDATA[<p>Hi,</p><p>What do you mean &quot;xml format&quot;?</p><p>The CFD data format is exactly the same as the currently used format for the Forex data. The file is stored as a CSV (Comma Separated Values). The format is well described in the program&#039;s help.&nbsp; See here: <a href="http://forexsb.com/help/manual/data_updating">Forex Rates update</a></p><p>You can use historical data from your broker. If you use MT, here you can find a step by step guide how to save the data <a href="http://forexsb.com/help/guide/metatrder_data">Meta Trader Historical Data</a></p><p>After saving the data file you have to add the new instrument: Menu Market -&gt; Edit Instruments</p><p>Make this and if you have additional questions ask here.</p>]]></content>
			<author>
				<name><![CDATA[Popov]]></name>
				<uri>https://forexsb.com/forum/user/2/</uri>
			</author>
			<updated>2009-01-04T17:52:09Z</updated>
			<id>https://forexsb.com/forum/post/1805/#p1805</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Stocks historical data]]></title>
			<link rel="alternate" href="https://forexsb.com/forum/post/1804/#p1804" />
			<content type="html"><![CDATA[<p>Where can I get quotes for shares in the xml format?</p>]]></content>
			<author>
				<name><![CDATA[Karl Marx]]></name>
				<uri>https://forexsb.com/forum/user/5/</uri>
			</author>
			<updated>2009-01-04T17:18:55Z</updated>
			<id>https://forexsb.com/forum/post/1804/#p1804</id>
		</entry>
</feed>
