Typical table with open / high / low / close / volume data for stocks.
Questions tagged [stock-data]
36 questions
3
votes
2 answers
Dividend rates and dates for multiple stocks at once using python
I am trying to download multiple stocks dividend amounts and respective dates using yfianance package and trying to save it in a python Data Frame.
I am using following code
import yfinance as yf
data = pd.DataFrame()
stock_list =…
Rizwan Ahmed
- 63
- 6
3
votes
2 answers
Unable to load data into mysql using python
I was not able to load symbol column into mysql. File name is BAJFINANCE.NS.csv
Date,Open,High,Low,Close,Adj Close,Volume
2002-07-01,5.239740,5.540930,5.239740,5.412680,0.063393,21923 …
Gower
- 139
- 7
2
votes
1 answer
How to write and append stock data for multiple tickers from Yahoo Finance url?
I have the following code and need to download data for multiple tickers from yahoo url:
import time
import datetime
import pandas as pd
#read ticker symbols from a file to a python list object named ticker
symbols = []
with open('ticker_list.csv')…
user19119294
- 21
- 2
2
votes
2 answers
ValueError: Error getting data from the api, no return was given. alphavantage
I was using following code to download the NSE stock data(indian stocks) :
from alpha_vantage.timeseries import TimeSeries
ts = TimeSeries(key='my api key',output_format='pandas')
data, meta_data = ts.get_daily_adjusted(symbol='VEDL.NS',…
Punit Kumar
- 21
- 3
2
votes
1 answer
How to get all Ticker symbols and its stock prices(csv format) using python?
I wanted all ticker symbols and its stock prices in csv format.
expected output:
Is there any solution to get all data in csv?
Download history stock prices automatically from yahoo finance in python
using this approach we can get data related to…
Anonymous
- 659
- 6
- 16
2
votes
1 answer
MySQL slow query with some specific values (stock data)
I have some stocks data like this
+--------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------------+------+-----+---------+-------+
| date | datetime | YES | MUL |…
r0beRT
- 21
- 2
2
votes
1 answer
mysql select query for candle stick market data
I am trying to select a summary of candle data from a mysql table that represents trading prices and volume of markets.
The table holds data for 1 minute candle data. I would like to get a 5 minute summary (essentially interpreting it as a 5 minute…
jamesrogers93
- 335
- 1
- 5
- 15
2
votes
1 answer
ohlc(open,high, low and close) record between two date range on different time internal(1,5,15,60,120) minute, 1 day even there are no record
What I have
1. MY Domain "User_Order"
CREATE TABLE `user_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`created_date` datetime DEFAULT NULL,
`fees` decimal(19,2) NOT NULL,
`instrument` varchar(255) NOT NULL,
`is_limit_order` bit(1)…
Md Imroz Alam
- 81
- 4
1
vote
1 answer
Showing Empty DataFrame as output
This is my code. I tried to concatenate the data but it is showing the empty dataframe. I want the details of symbols provided in the list as output which will be in the form of dataframe.
import pandas as pd
from nsepy import get_history
from…
Saniya Pathan
- 41
- 3
1
vote
1 answer
Plotting with FigureCanvasTkAgg overrides mplfinance custom color and grid
I need help, I am trying to figure out why the style i chose in mplfinance is not working when I plot it into a tkinter canvas plot.
This is my code:
from tkinter import *
import datetime as dt
import yfinance as yf
import matplotlib.pyplot as…
Jorge Alvarez
- 104
- 4
1
vote
0 answers
Pandas / SQL Datatype Difficulties?
I have some data that looks like this
Open High Low Close Volume Instrument
Date
2018-09-02 07:00:00-04:00 7269.0 7274.0 7213.0 7240.5 2321665 XBTZ18
2018-09-02 08:00:00-04:00 7240.5 7270.0 7240.5 …
Merv Merzoug
- 1,149
- 2
- 19
- 33
1
vote
0 answers
Issue with Pandas - read_sql
I have the problem with pandas method: read_sql
I select four columns from database and about 100 rows.
import pymysql
sql = "SELECT `opens`,`high`,`low`,`close` FROM `dbname`"
result = ""
try:
with c as cursor:
cursor.execute(sql)
…
mrberner
- 96
- 2
- 8
0
votes
0 answers
Pandas datetimeindex intraday min, max, first, last and sum
I have 5 minutes stock data dataframe for multiple days. I am trying to get first, current, min, max values for columns within the day in same index and same dataframe.
I have a pandas dataframe with 5 minutes stock…
user22245178
- 1
- 1
0
votes
0 answers
String indices must be integers not str? What's going on here
My Code:I'm learning to write the basic intro to a finance program that I found on YouTube. All necessary packages have been installed and updated just to make sure. In line 19 using the get_data_yahoo function is the way I'm calling upon the stock…
warnie conley
- 1
- 1
0
votes
2 answers
MongoDB: Can I store stock data in this way?
{
{
"symbol": "MSFT",
"close": [0, 1, 2, 3, 4, 5],
"open": [0, 1, 2, 3, 4, 5],
"high": [0, 1, 2, 3, 4, 5],
"low": [0, 1, 2, 3, 4, 5],
"volume": [0, 1, 2, 3, 4, 5],
"dates": ["2022-01-01", "2022-01-02", "2022-01-03",…
Allen Ye
- 15
- 1
- 3