decimal.InvalidOperation: Invalid literal for Decimal: 'Bid'

[mhallsmoore]

decimal.InvalidOperation: Invalid literal for Decimal: 'Bid'

[JamesKBowler]

Issue resolved in the below Pull Request
https://github.com/mhallsmoore/qsforex/pull/23

Cheers!

[yabolgha]

Just try to set "header=false" in read_csv method when you are reading those files in CSV_DATA_DIR

…

Sent from my iPhone

On Dec 4, 2016, at 11:18 AM, JamesKBowler ***@***.***> wrote: When running the backtest for mac.py I get an error as per below. (qsforex) ***@***.***:~/Projects/qsforex$ python examples/mac.py Traceback (most recent call last): File "examples/mac.py", line 29, in backtest.simulate_trading() File "/home/jbowler/venv/qsforex/lib/python2.7/site-packages/qsforex/backtest/backtest.py", line 81, in simulate_trading self._run_backtest() File "/home/jbowler/venv/qsforex/lib/python2.7/site-packages/qsforex/backtest/backtest.py", line 57, in _run_backtest self.ticker.stream_next_tick() File "/home/jbowler/venv/qsforex/lib/python2.7/site-packages/qsforex/data/price.py", line 182, in stream_next_tick bid = Decimal(str(row["Bid"])).quantize( File "/home/jbowler/ProgramData/anaconda2/lib/python2.7/decimal.py", line 547, in new "Invalid literal for Decimal: %r" % value) File "/home/jbowler/ProgramData/anaconda2/lib/python2.7/decimal.py", line 3873, in _raise_error raise error(explanation) decimal.InvalidOperation: Invalid literal for Decimal: 'Bid' How is this fixed? Thank-you — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[JamesKBowler]

Hi @yabolgha,
Thank you for responding so quickly and my apologies for not...Tis the season.

I tried your suggestion however this did not work and gave a traceback below. I received the same error when set True. The error above was given when set to None.

(qsforex) jbowler@GEN-U-QS-01:~/projects/qsforex$ python examples/mac.py
Traceback (most recent call last):
File "examples/mac.py", line 27, in
equity=settings.EQUITY
File "/home/jbowler/venv/qsforex/local/lib/python2.7/site-packages/qsforex/backtest/backtest.py", line 29, in init
self.ticker = data_handler(self.pairs, self.events, self.csv_dir)
File "/home/jbowler/venv/qsforex/local/lib/python2.7/site-packages/qsforex/data/price.py", line 107, in init
self.file_dates[self.cur_date_idx]
File "/home/jbowler/venv/qsforex/local/lib/python2.7/site-packages/qsforex/data/price.py", line 143, in _open_convert_csv_files_for_day
names=("Time", "Ask", "Bid", "AskVolume", "BidVolume")
File "/home/jbowler/venv/qsforex/local/lib/python2.7/site-packages/pandas/io/parsers.py", line 646, in parser_f
return _read(filepath_or_buffer, kwds)
File "/home/jbowler/venv/qsforex/local/lib/python2.7/site-packages/pandas/io/parsers.py", line 389, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
File "/home/jbowler/venv/qsforex/local/lib/python2.7/site-packages/pandas/io/parsers.py", line 726, in init
self.options, self.engine = self._clean_options(options, engine)
File "/home/jbowler/venv/qsforex/local/lib/python2.7/site-packages/pandas/io/parsers.py", line 858, in _clean_options
_validate_header_arg(options['header'])
File "/home/jbowler/venv/qsforex/local/lib/python2.7/site-packages/pandas/io/common.py", line 195, in _validate_header_arg
raise TypeError("Passing a bool to header is invalid. "
TypeError: Passing a bool to header is invalid. Use header=None for no header or header=int or list-like of ints to specify the row(s) making up the column names