Stack Overflow
Stack Overflow

Questions tagged [stock-data]

Typical table with open / high / low / close / volume data for stocks.

36 questions
0
votes
1 answer

Filter date and time in Google Sheets Query

I use a formula like this to get stock data: =IMPORTDATA("https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY_EXTENDED&symbol=IBM&interval=15min&slice=year1month1&apikey=demo") Basically my goal is to filter the data by date and time…
PhilNos
  • 15
  • 5
0
votes
0 answers

Google sheets: How to get Implied volatility data for stock for given date range

Using the formula below, I am successfully able to find daily stock data for any ticker for a given date range. Is there some way to get (or calculate) the daily implied volatility for the this downloaded data? GOOGLEFINANCE("GOOG", "open",…
Sinha
  • 431
  • 1
  • 5
  • 12
0
votes
2 answers

PHP append duplicate value

I'm trying to append data in file I have an array result contains this value : Array ( [0] => Array ( [name] => Fanny [asset] => 1034 ) ) Array ( [0] => Array ( [name] => Gabriel [asset] => 1089 ) ) Array ( [0] => Array ( [name] => Martin…
All
  • 43
  • 4
0
votes
1 answer

Speed - CSV vs MariaDB fetching stock data (python)

I like the idea of having my historical stock data stored in a database instead of CSV. Is there a speed penalty for fetching large data sets from MariaDB compared to CSV
Sebastian Jensen
  • 5
  • 1
0
votes
0 answers

Why is this code not downloading the data in real time?

I have a problem which I don't know how to solve (I'm a beginner in coding). This program is supposed to scrape stock price data from yahoo finance: import bs4 from bs4 import BeautifulSoup import requests import pandas as pd import datetime as…
Dominik Pucuła
  • 11
  • 1
0
votes
1 answer

How can I make a loop with tickers created in Excel in R?

I am trying to make a loop in R with tickers I have created in Excel. I am trying to collect stock data from Yahoo finance, and the idea is that R is going to read the name of the stock from the Excel file, and then collect it from Yahoo Finance and…
Silje Bue
  • 1
0
votes
1 answer

How can I slice a multiIndex dataframe with stocks data?

I have downloaded stock data with yfinance and I'm trying to slice the DataFrame into one df for each stock, but I really don't know how to do it. The data is a df with multiIndex but the columns were set with tuples of the infos and the tickers…
Grego
  • 11
  • 2
0
votes
0 answers

Extracting data from Yahoo! Finance using Beautiful Soup

I am currently trying to create a stock information script. However, I am only able to retrieve the data from the initial page of the stocks, and not the key statistics page. This is the page I am trying to obtain data…
Zane Hutchison
  • 1
0
votes
0 answers

Downloading data from webpage (yahoo finance) that is not a csv

I would like to download the float data that is on Yahoo Finance for multiple stocks at the same time, but I have no idea how to code this. I am a little familiar with python and because of Stackoverflow I have been able to download .csv historical…
Hoogoo
  • 15
  • 1
  • 8
0
votes
1 answer

Classification of Stock Prices Based on Probabilities

I'm trying to build a classifier to predict stock prices. I generated extra features using some of the well-known technical indicators and feed these values, as well as values at past points to the machine learning algorithm. I have about 45k…
C.Acarbay
  • 424
  • 5
  • 17
0
votes
1 answer

User input inside " ts.get_intraday "

I'm fairly new to python and I promise I looked around for a while before I came here but I'm trying to make a stock reader in which someone can just type in whichever stock they want and it shows the data for it. So far everything is going well but…
Bakhrom Abdurakhmonov
  • 1
0
votes
3 answers

How to optimize a large mysql table (stock data)

I have a table with following structure, `trading_daily_price` ( `id` int(11) NOT NULL PRAMARY AUTO_INCREMENT, `date` date DEFAULT NULL, `Symbol` varchar(20) DEFAULT NULL, `Market` varchar(12) DEFAULT NULL, `QuoteName` text, …
Rajib Deb
  • 51
  • 1
  • 10
0
votes
0 answers

Loading data from multiple CSV into MySQL

I am trying to load multiple csv files into mysql to create a single table of those multiple files. I've a table named symbols loaded in mysql which has one column named as ticker and all the row values represent symbols like A, B, C etc. I would…
user7616021
0
votes
2 answers

Splitting one large comma separated row into many rows after number of values

I'm rather new to MySQL so apologies if this is an intuitive problem, I couldn't find anything too helpful in stackoverflow. I have a rather large amount of financial data in one row currently, with each value separated by a comma. 12 values equals…
Mikey Mike
  • 79
  • 1
  • 9
0
votes
0 answers

Scrape CSV data to SQL table using PHP, LOAD DATA from URL with Javascript object, (beginner)

(I'm learning and not a pro, so please excuse any faux pas) I am aware that the PHP, LOAD DATA function may be what I need, but I can't get to the file behind the Java Object. I am trying to update a SQL table, i.e. overwrite matching dates, with…
user2299779
  • 21
  • 6
1
2
3