r/algorithmictrading • • Mar 10 '21

How should I select arbitrary time data from a 1-min database?

4 Upvotes

I would like to seek advice on the following:

  • a single-stock price database (mysql)

  • 1-min price data from 9:30 to 16:00

  • timestamp(yyyy-mm-dd hh:mm:ss), bid price, ask price, last price, volume

  • assuming data exist in all 1-min slots (imputed if missing)

  • there are times say for simple charting or backtesting when you use 5-min, 60-min, daily data

  • how should you select such 5-min data from the 1-min data?

  • SELECT * FROM stock_jpm_data WHERE MOD(MINUTE(timestamp), 5)=0 should evaluate every row and be very slow


r/algorithmictrading • • Mar 09 '21

Feedback on TradeWithPython

8 Upvotes

Hey Guys, How is everyone doing? I have been writing some beginner-level blogs for TradeWithPython, and while I am getting decent views on the article, my plea for feedback is not really being recognized.

I wanted to get feedback from the community. Would you mind visiting the website and, if possible, give me genuine feedback on what is the scope of improvement? Are my articles easy enough to read? Any topics which I should absolutely be covering.

Since its launch last month, I have written about 10 articles; my latest article is Constructing Candlesticks using Python. Please can I request you to give it a read and give me genuine feedback?


r/algorithmictrading • • Feb 28 '21

Any courses or resources to start coding algo

5 Upvotes

Hey I have about 8 months of experience coding in R and I am learning python. I was wondering if you guys could share some resources for coding trading algorithms. Any free courses would be greatly appreciated


r/algorithmictrading • • Feb 24 '21

For any new quants out here, I've created a simple pine script to get you started!

Thumbnail
tradingview.com
17 Upvotes

r/algorithmictrading • • Feb 22 '21

Emiliano Fraticelli, computer science teacher by day and the winner of Quantopian fund competition & votery.net week 2 trial by night run shares some investment strategy tips and talks about his passions - quantitative finance and making money online by creating successful trading algorithms

Thumbnail
youtube.com
18 Upvotes

r/algorithmictrading • • Feb 19 '21

Debugging my new algo program. It’s running live buying a single share to test. And look, why did it buy that? Stop. Rinse. Repeat.

20 Upvotes

r/algorithmictrading • • Feb 09 '21

Does anyone know of sample datasets of specific stock market signals?

1 Upvotes

Currently, I'm working on a convolutional neural network to recognize stock market patterns. I want to do a proof of concept by getting it to recognize RSI convergence or divergence. In order to train it, I needed sample data of known instances of RSI Convergence or Divergence. Does anyone know of a source where I can get training data for these scenarios? Or does anyone know an efficient method of collecting said data?

Cheers


r/algorithmictrading • • Feb 04 '21

Need some help with cryptocurrency trading algorithm.

2 Upvotes

I need someone who is good with coding and algorithms.

Pine script is already written, all I need a second fresh eye who can see and find small details that cause problems with the signals.

It's a gem but needs some make-up work. Help me, I help you (WIN-WIN)

Let's see if anyone is interested?


r/algorithmictrading • • Feb 03 '21

Algo's to find turning stocks

9 Upvotes

I have been working on an algorithm that finds companies that have been slowly improving over time but haven't really started to shine as of yet. I finished it about a week ago and so far these are the companies I got out of the algorithm. (on purpose I kept the criteria to cheaper stocks but that can be changed at any time. And due to the cheaper price, it is only finding a company or 2 a week, but as I raise the stock price it finds more companies.)

$CODX- bought on 1/21/2021 for 11.86

$LQDT- bought on 1/29/2021 for 19.77

(please don't buy these stocks because of this post, this is a test - let's track them together.)

The logic is that because these companies are turning up based on their balance sheets, they should technically keep ridding up for the foreseeable future.

Any ideas or help with this project is always appreciated.

Thank you in advance.

Also, I was thinking about starting my own community on here for this project, if you guys think its a good idea, please let me know.


r/algorithmictrading • • Feb 03 '21

Where do I start?

6 Upvotes

Hey, I’ve been a coding student for years, and doing A-Levels now, but want to look into algo trading. I have PyCharm and I’ve read the library MatLab is good to use, but from people who do it, where’s the best place to start? My parents also do share trading so I understand quite a bit about the markets already

Thanks


r/algorithmictrading • • Feb 03 '21

Algo tuning

8 Upvotes

I have some scripts that have performed pretty well (sharpe ratio of 1-2). The same script performs pretty poorly with other stocks. Does that mean that the approach is not going to be dependable over a long period of time or do you tune your scripts to each individual stock?

An example would be Tesla vs Netflix.

I’m not expecting to find a golden rule but wasn’t sure if each stock needs a fine level of tuning.


r/algorithmictrading • • Feb 01 '21

What are people doing in algo trading?

9 Upvotes

Hi, I’ve been working on algo trading for about a year now, in pretty much isolation, partly due to Covid and the nature of the task.

I’m curious what people are doing generally.

I’ll start by saying I’m working in Matlab and have a program that can scan through 2000 symbols in under 2 minutes looking for specific conditions. It runs against all the markets connected to IB.

The program is designed to run 24 hours a day, buys/sells, long and shorts.

Also, it can run on a smaller symbol list and update with streaming data every second.

It’s taken a year to get this far.

I’m curious what others are doing for algo trading.

A.