Stack Overflow
Stack Overflow

Questions tagged [ohlc]

84 questions
0
votes
1 answer

Find highest high, considering today's rolling intraday high, and the previous day's high

Building off of my last question, what I need to do now is find the rolling().max() or rolling max price for each individual day. What I need is to create a column that contains the MAX of either yesterday's highest high price, or today's rolling…
wildcat89
  • 1,159
  • 16
  • 47
0
votes
2 answers

How to get prior close when you have all stocks in a single DF?

Sorry for the noob question. I have a bunch of stocks in a sqlite3 database: import pandas as pd import sqlite3, config connection = sqlite3.connect(config.db_file) connection.row_factory = sqlite3.Row df = pd.read_sql('SELECT * FROM…
a7dc
  • 3,323
  • 7
  • 32
  • 50
0
votes
2 answers

How to scale and print an array based on its minimum and maximum value?

I'm trying to scale the following NumPy array based on its minimum and maximum values. array = [[17405.051 17442.4 17199.6 17245.65 ] [17094.949 17291.75 17091.15 17222.75 ] [17289. 17294.9 17076.551 17153. ] [17181.85 17235.1 …
Rishabh Sahni
  • 43
  • 7
0
votes
1 answer

Filter out Down-candles to only include Up-candles in calculations in Pine Script

So, here's what I'm aiming to do: I want to write a script that uses OHLC-data exclusively from UP-candles [close > open] to calculate % change from Open to High, Close to High, and Open to Low, then take a (moving) average of those values to…
Daniel Bauer
  • 15
  • 2
0
votes
1 answer

Trading View API is not able to show the price on price-scale when it's small

Check my OHLC Data for Plotting Candlesticks with Trading View API. I am using this HTML and Script to Plot the Data : Plot
Rakesh Poddar
  • 183
  • 3
  • 11
0
votes
1 answer

Python pandas resample 15 minutes ohlc to 75 minutes ohlc

Below is the dataframe for one of the stock in indian market. open high low close volume date 2021-06-17 09:15:00+05:30 815.55 819.15 807.05 818.45 54372 2021-06-17…
Vilas
  • 1,695
  • 1
  • 13
  • 13
0
votes
0 answers

Python Convert Stock Market Data to Periods

i have a data table like below. The rows come from a data source for every minute but sometimes may come same data or it does not come. For example, i have data for 13:11:49 but do not have 13:12:49, and i have for 13:13:49. What i want to do is…
FCTURKEY
  • 13
  • 5
0
votes
1 answer

Syncrhonize timescale db to work with custom intervals

I am willing to collect candle price stock data on specific time intervals using timescaledb continous aggregations, such as 37 minutes and my intervals will start every day at 00:00. So for example, I am willing to have an interval starts each day…
Ohad Koren
  • 1
  • 1
0
votes
1 answer

First 5 min candle OHLC with valuewhen

I am using below lines of code to get first 5 min candle HLOC and it is working correctly. Is there any better way of doing this? I want to reduce security function calls. is_newbar(res) => change(time(res)) != 0 hl_5minFunc(sx) => h_5 =…
CVR
  • 1
0
votes
2 answers

How to show the X-axis date ticks neatly or in a form of certain interval in a plotly chart

I am making an OHLC graph using plotly. I have stumbled across one issue. The labels in the x-axis is looking really messy . Is there a way to make it more neat. Or can we only show the extreme date values. For example only the first date value and…
Ritesh Singh
  • 73
  • 1
  • 8
0
votes
2 answers

Grouping the OHLC data into multiple time intervals and get the values in Pandas

I have a CSV file attached below, I need to split the time for 1 day into 4 intervals, i.e: 9:15-10:00, 10:01-12:00, 12:01-14:30 & 14:31-15:30 and get the values of 'Open' as the first value in every interval, 'High' as the max value, 'low' as the…
user16269182
  • 1
  • 2
0
votes
1 answer

How to widen the middle portion of OHLC chart , plotly ? The middle portion consists of Open & Close values

I was trying to make an OHLC chart using plotly and I am successfully able to do it.I am using Yfinance library to get the data and plotting an OHLC chart for certain stocks. The code that I wrote for it as. fig =…
Ritesh Singh
  • 73
  • 1
  • 8
0
votes
2 answers

VBA - Modification of SourceData (Dynamic Range) of existing STock OHLC Chart

I am working on Stock OHLC Chart present in Sheets("Exhibit") and selecting Data from Sheets("75Min"). However i am succeeding to choose appropriate data range but can not add at Line Nu 15 .SetSourcedata, could you please help me to get out from…
Imran Shaikh
  • 11
  • 4
0
votes
1 answer

Python Pandas resample year data using day time frame data

This is small sample of the daily ohlc data I have stored in df1. date open close high low 2019-01-01 00:00:00 3700 3800 3806 3646 2019-01-02 00:00:00 3800 3857 3880 3750 2019-01-03 00:00:00 3858 3766 …
psychoMLM
  • 3
  • 2
0
votes
1 answer

Python Plotly - removing slider from plotly subplot

I am creating a figure with a number of subplots using plotly. One of the figures is an Ohlc/ candlestick that has a slider. In case of a single plot, the slider can be removed by fig.update_layout(xaxis_rangeslider_visible=False). However, this…
user14396236
  • 19
  • 3
1 2 3
4
5 6