coulan88

1

votes
1

answer
47

views

SQLITE JDBC driver prepared statement fails (internal pointer 0)

SQLite JDBC driver version 3.21.0 (the latest). Summary A prepared statement is opened for multiple insert operations on a table, but is unable to survive primary key violations. If one 'bad' insert fails due to a Primary Key violation, the prepared statement is unable to process subsequent 'good' i...
coulan88
1

votes
1

answer
1.4k

views

R TTR Package MACD Function

I am having difficulty reconciling the output of the MACD function in the R package TTR ver 0.22 (which by the way is an excellent package that I use a lot, thanks to Joshua). A specific example is taken from daily closing prices for APPL 19 Feb 2013 to 22 May 2013. I chose this dataset as there is...
coulan88
2

votes
1

answer
644

views

Pandas Dataframe Resample OHLC has wrong open price

I am unable to generate 'accurate' OHLC data from tick data using pandas DataFrame.resample() ver 0.18. Specifically I get a 'future leak' at the open price of those bars where the price continues across an interval. Reproduceable Example: import pandas as pd import numpy as np np.random.seed(1234)...
coulan88
2

votes
0

answer
160

views

Timeseries Plot Fails in Pandas 0.21 (OverflowError)

On Pandas 0.21 and matplotlib version 2.1, I can no longer plot timeseries dataframes. I get an OverflowError error from within matplotlib: /usr/local/lib/python3.6/dist-packages/matplotlib/dates.py in _from_ordinalf(x, tz) 255 ix = int(x) --> 256 dt = datetime.datetime.fromordinal(ix).rep...
coulan88