使用python读取Amibroker价格交易量数据

Question

我想阅读使用python的Amibroker股票符号的价格交易量数据。我找不到任何有用的谷歌做这件事。有人能帮忙吗？

Answer 1

我不知道你的情况是什么，但你有几个选择。

最终，存储的有关股票的所有信息都在AB数据库中，您可以从AFL访问该数据库。因此，要将值输入Python，您可以创建一个文本文件，您的Python代码可以读取该文本文件。

下一个选项是直接与AB对象交互，参见指南。我不知道用Python怎么能做到这一点。

下面是COM对象指南，引号如下：

类表示一条价格数据。

https://www.amibroker.com/guide/objects.html

下面的链接是我发布的关于AB COM互操作的另一个答案的一个想法。

Equivalent code of CreateObject in C#

塞特莫

Answer 2

您可以尝试将这个javascript (我将Amibroker示例修改为Python )更改为Python。这个javascript将把Amibroker数据库转储到一个文件中。这个脚本可以让您了解如何访问Amibroker中的数据库。

​

function FormatFloat( number )
{
	number = 0.001 * Math.round( number * 1000 );
	str = number.toString();
	return str.substring( 0, str.indexOf(".") + 4 );
}

var oAB = new ActiveXObject("Broker.Application"); 
var fso = new ActiveXObject("Scripting.FileSystemObject"); 

/* Indicate the location and file name for the database dump. */
file = fso.OpenTextFile( "C:\\Info.txt", 2, true ); 

/* Indicate the location and name of the database to dump. */
oAB.LoadDatabase("C:\\Program Files (x86)\\AmiBroker\\Data");

var oStocks = oAB.Stocks; 
var Qty = oStocks.Count;

for( i = 0; i < Qty; i++ ) { /* Loop through all the stocks in the database. */
	oStock = oStocks(i);
	for (j = 0; j < oStocks(i).Quotations.Count; j++) { /* Loop through all the ohlcv in each stock. */
		oQuote = oStock.Quotations( j );
		var oDate = new Date( oQuote.Date );
		file.WriteLine( oStocks(i).Ticker + "," + 
			(oDate.getMonth()+1) + "/" + oDate.getDate() + "/" + oDate.getFullYear() + "," + 
			FormatFloat( oQuote.Open ) + "," + 
			FormatFloat( oQuote.High ) + "," +
			FormatFloat( oQuote.Low ) + "," +
			FormatFloat( oQuote.Close ) + "," + 
			Math.round( oQuote.Volume )  );
	}
} 
file.Close(); 
WScript.Echo("Export finished" ); ​

​

Answer 3

//Price Volume of the ticker (Formula: Close x Volume)

  Price_Volume = C*V

//Price Volume of specific ticker (eg. SPY) (Formula: Close x Volume)

  Price_Volume_SPY = foreign("SPY","C")*foreign("SPY","V")

//Yesterday Price Volume of specific ticker (eg. SPY) (Formula: Close x Volume)

  Yesterday_Price_Volume_SPY = Ref(foreign("SPY","C"),-1)*Ref(foreign("SPY","V"),-1)