@z_kvn How did it go?

@li-mike Not much I can respond to in this post. Maybe explain it a bit better and ill give it a shot

@pierre-cilliers-0

The entire code is like that.

backtrader_demo Test areas 1. Data Feed from MySQL

from future import(absolute_import, division,
print_function, unicode_literals)

import datetime
import os.path
import sys

import backtrader as bt
import numpy as np

import mysql.connector
import MySQLCredentials as mc

import pandas
from pprint import pprint

Data to MySQL

connection = mysql.connector.connect(
host=mc.host,
port=mc.port,
user=mc.user,
password=mc.password,
database='stock_db')

cerebro = bt.Cerebro()

Datas are selected from TABLE in MySQL

temp_table = "goog"

CREATE db table "stock_temp"

sql = """SELECT * FROM """ + temp_table + """;"""
cursor.execute(sql)
stock_data = cursor.fetchall()

dataframe = pd.DataFrame(stock_data, columns=[
'date', 'open', 'high', 'low', 'close', 'volume'])
dataframe["date"] = pd.to_datetime(dataframe["date"])

class pandaDataFeed(bt.feeds.PandasData):
#lines =('line_name/newparameter')
params = (
('fromdate', dt.datetime(2005, 1, 1)),
('todate', dt.datetime.now()),
('dtformat', '%Y-%m-%d'),
('datetime', None),
('open', 'open'),
('high', 'high'),
('low', 'low'),
('close', 'close'),
('volume', 'volume')
)

data = pandaDataFeed(dataname=dataframe)
cerebro.adddata(data)

cerebro.run

cerebro.plot()

@run-out that is smart,thanks

Hi,

Good to know about the information you have shared with us. I think your tips and strategies could help the writers to do their works properly about Java.

@borutf Thank you! It work.

I'm in the same space, it seems to take daily closes as opposed to if high or lows are hit.

I'll let you know if i find something in the documentation.

Cheers

@tianjixuetu Hi, can we have a little discussion about how to speed the backtest? Recently I am trying to find a new way to solve it. My Wechat Id is 13247198760