fbpx

My Postgres SQL for positions to test this Kelly Criterion Matlab script for self imposed risk management during trading

(Last Updated On: October 30, 2014)

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’)

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Subscribe For Latest Updates

Sign up to best of business news, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.

NOTE!

Check NEW site on stock forex and ETF analysis and automation

Scroll to Top