My Postgres SQL for positions to test this Kelly Criterion Matlab script for self imposed risk management during trading
Nothing special but use Razor SQL to save yourself a hassles of manually typing this up in some shell script
Join my FREE newsletter to learn about this Postgres SQL data base for trading
INSERT INTO test.test.positions
(idx, longentryprice, longentrytimestamp, longentrytimestr, longexitprice, longexittimestamp, longexittimestr, longlowstop, longlowtarget, longsofttargperc, longstoplossper, longsymbol, longupstop, longuptarget, shortentryprice, shortentrytimestamp, shortentrytimestr, shortexitprice, shortexittimestamp, shortexittimestr, shortlowstop, shortlowtarget, shortsofttargperc, shortstoplossper, shortsymbol, shortupstop, shortuptarget)
VALUES
(1, ’10’, 0, ‘0’, ’15’, 0, ‘0’, ‘0’, ‘0’, 0, 0, ‘F’, ‘0’, ‘0’, ‘1’, 0, ‘0’, ‘1.5’, 0, ‘0’, ‘0’, ‘0’, 0, 0, ‘GM’, ‘0’, ‘0’)
or use this:
INSERT INTO test.test.positions
(idx, longentryprice, longentrytimestamp, longentrytimestr, longexitprice, longexittimestamp, longexittimestr, longlowstop, longlowtarget, longsofttargperc, longstoplossper, longsymbol, longupstop, longuptarget, shortentryprice, shortentrytimestamp, shortentrytimestr, shortexitprice, shortexittimestamp, shortexittimestr, shortlowstop, shortlowtarget, shortsofttargperc, shortstoplossper, shortsymbol, shortupstop, shortuptarget)
VALUES
(1, ’10’, 0, ‘0’, ’15’, 0, ‘0’, ‘0’, ‘0’, 0, 0, ‘IBM’, ‘0’, ‘0’, ‘1’, 0, ‘0’, ‘1.5’, 0, ‘0’, ‘0’, ‘0’, 0, 0, ‘AAPL’, ‘0’, ‘0’)