Questions tagged [ohlc]
84 questions
12
votes
5 answers
I got: chart_studio.exceptions.PlotlyRequestError: Authentication credentials were not provided
I am working locally(in my pc) just testing and learning PLOTLY 3.7.5.
with anaconda env active.
The code example is given by plotly
Code:
import plotly.plotly as py # Here all begins (Look)
# import chart_studio.plotly as py # inted of the line…
Boris Fischman
- 121
- 1
- 1
- 3
6
votes
2 answers
Find minimum and maximum values in OHLC data
I would like to find (in python) the local minimum and maximum values in OHLC data, under the condition that the distance between these values is at least +-5%.
Temporal Condition
Note that
for an UP movement (close>open), low price comes BEFORE…
sono
- 266
- 2
- 7
- 18
5
votes
2 answers
Gap Filling OHLCV (Open High Low Close Volume) in TimescaleDB
I have some OHLCV data stored in TimescaleDB which contains missing data during certain time ranges. This data needs to be resampled to a different time period (i.e. 1 day) and contain contiguous, ordered time buckets.
TimescaleDB provides the…
Nyxynyx
- 61,411
- 155
- 482
- 830
2
votes
3 answers
Find Yesterday's High Price by Merging Two DF's on Datetime and Date Columns
I'm trying to merge two df's, one df has a datetime column, and the other has just a date column. My application for this is to find yesterday's high price using an OHLC dataset. I've attached some starter code below, but I'll describe what I'm…
wildcat89
- 1,159
- 16
- 47
2
votes
1 answer
Getting multiple cryptos' ohlc values in ccxt or binance python api?
I'm trying to create an automated bot according to my strategy but I'm struggling with a few things:
1- In ccxt, I can get OHLC data of a specified symbol. But I couldn't find any data on both documentation and google etc, about getting multiple…
yktrcn
- 29
- 1
- 6
2
votes
1 answer
How to change the Y-Axis in Plotly to go from scientific to exponential or plain?
Ive seen many different answers, but need one specifically for the use of Plotly in Python....my code is below, but the Y axis doesn't come back in basic decimal points (I believe it come back in some micro format where instead of .000258 it will…
Kenneth Lott
- 59
- 7
2
votes
2 answers
How to resample ohlc data properly in pandas / custom fill method per column
I have got OHLC data with missing time frames. Suppose I have the following pandas dataframe denoted by the variable df:
Open High Low Close
2019-04-19 00:00:00 0.67068 0.67123 0.67064 0.67123
2019-04-19…
freak11
- 341
- 3
- 16
2
votes
2 answers
Charting OHLC candle with SMA 200 using mplfinance plot function
I'm using mplfinance plot function to draw OHLC candlestick chart of a symbol. OHLC data is of 2 min timeframe. Also, I'm plotting sma 20 period and sma 200 period on the same chart. Because of sma200, the number of candles which are displayed on…
Naseem Khan
- 73
- 12
2
votes
0 answers
Highcharts Highstock How to Plot OHLC Bar Chart Using Embedded CSV Data?
Working Plot Without Using CSV Data
Using this example:
http://jsfiddle.net/grw3hamv/
I wrote the following code to plot a simple ohlc chart:
SystemTheory
- 339
- 3
- 15
2
votes
0 answers
How can I use my own data for calculations in Pine Script - Tradingview?
there I am new to Pine Script and the Rest API. The Rest API is for brokers. Have you implemented the Rest API. I need to do this:
I am getting OHLC data from a different source. I want to send this custom data to PINE script in Trading View and…
Rushi Narasimha
- 21
- 1
2
votes
1 answer
Bitstamp API returns wrong number of klines when asking latest OHLC
Problem
Working on Bitstamp HTTP API, I found something very odd.
Whenever I ask for the latest OHLC data using the following request:
https://www.bitstamp.net/api/v2/ohlc/{currency_pair}/
required parameters are written in the documentation page…
Mahdi Massahi
- 21
- 3
2
votes
1 answer
How can we resample OHLCV 1 minute Pandas Dataframe into a 5 minute Dataframe - 2020 method?
This question has been answered many times before. However, whatever I try, either the methods have been deprecated or completely changed. That is why I want something that works in 2020 based on the Dataframes I have listed below.
Let me explain…
OldAgedNewbie
- 45
- 5
2
votes
2 answers
Merging historical and live stock price data in pandas
First I create a Pandas dataframe containing historical 1min OHLCV data for the day, e.g.:
open high low close volume
date
2019-10-30 07:55:00 3034.00 3034.25 3033.75 3034.00 209
2019-10-30 07:56:00…
quantllama
- 107
- 1
- 8
1
vote
1 answer
PostgreSQL resample 1 minute OHLCV candle data into 5 minute OHLCV candle data
I have a postgreSQL database with the following columns:
timestamp - Unix timestamp in milliseconds
open - The first traded price
high - The highest traded price
low - THe lowest traded price
close…
Quantitative
- 51
- 2
- 6
1
vote
1 answer
How to pass data to Plots OHLC function in Julia
I'm having an issue figuring out how to get data from a dataframe in this format:
These are the types that get printed from each column:
DataType[Any, Any, Any, Any, Any]
This is the error i'm getting and already tried converting the types without…
Canichim
- 21
- 4