Typical table with open / high / low / close / volume data for stocks.
Questions tagged [stock-data]
36 questions
0
votes
1 answer
Importing a txt to MySQL with different date format
What I want to do is transfer the "12/26/17 14:30" in txt to "2017-12-26 14:30:00 " in MySQL
I've already tried this Importing a CSV to MySQL with different date format0
So my code looks like this
create_tb_str = r'''DROP TABLE IF EXISTS…
Chin-I
- 1
0
votes
0 answers
sql How to turn row values into columns in Mysql?
I have got a vast stock data in mysql in the following format...
date symbol open high low close volume
2017-11-07 stockA 8.9 8.92 8.88 8.9 68987
2017-11-08 stockA 8.91 8.95 8.9 8.92 …
Ben Tse
- 1
- 1
-1
votes
1 answer
(Python/MySQL/JSON) Not enough arguments for format string
Can anybody help me figure out what I'm doing stupidly? I'm attempting to propagate an SQL table with financial data from a json file. I get the error in the title, but I can't seem to figure out where it's coming from.
import json
import…
Mikey Mike
- 79
- 1
- 9
-1
votes
1 answer
inserting data into mysql database with python
I am trying to insert stock market csv data that I downloaded from Yahoo finance into a mysql table named 'TEST' that is in
a database named 'stocks' but I am getting an error code from python:
InternalError: (1292, "incorrect date value: 'Date…
Mattytripps
- 57
- 7
-3
votes
1 answer
Yfinance.download() Auto Adjust=True - What does it actually do?
What does auto_adjust=True do while downloading the historical data of a stock using the yfinance module in Python? I found no official documentation.
algotrading101 says it adjusts all OHLC (Open/High/Low/Close) prices. However, this StackOverflow…
amp1590
- 43
- 8
-3
votes
1 answer
Is there a better way to webscrape MSFT data in shorter lines? I have tried it already but get the issue 'module' object is not callable
tried following the same method, didnt work out
import bs4
import requests
from bs4 import BeautifulSoup
import urllib.request
#data I want to pull then push a while loop to get it regularly by the minute
r =…
Akash Chugh
- 1
- 1