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!
Don't miss out!
Get my TRADE LIKE A BOSS 2 PDF Books

You will received instantly the download links.

Invalid email address
Give it a try. You can unsubscribe at any time.

NOTE!

Check NEW site on stock forex and ETF analysis and automation

Scroll to Top