coulan88
4 questions
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...
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...
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)...
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...