The price of a stock as quoted by an exchange at a given time. May include additional information such as the latest bid price and bid lots, and/or ask price and ask lots.
Questions tagged [stockquotes]
289 questions
0
votes
0 answers
Issues with beautifulsoup.find() in python
I am trying to make a simple web scraper with python to get stock data. My code was working not long ago and I don't believe I changed anything but now I'm getting the following error:
File "tradingProgram.py", line 69, in
…
0
votes
1 answer
loop from a list to replace in a code for API
I am trying to extract data using API from the web. What I am trying to do is call for the current/historical stock prices of certain company and store the information in a dataframe or a sqlite database. I have a code where I can call for…
user13458293
- 1
- 1
0
votes
0 answers
Keep getting the ValueError 'Index contains duplicate entries, cannot reshape'
I want to pull ticker data from the all the sp500 stocks from yahoo.
I saved the sp500 ticker symbols into a list from a local csv file that I made.
When when I run the following code, I get the:
ValueError 'Index contains duplicate entries,…
Bemz
- 129
- 1
- 16
0
votes
1 answer
Finding Lower Low in df but got Can only compare identically-labeled DataFrame objects
I have stock prices as df in this shape
I'm trying to find to find the lower low as I move from row to row and also higher high using the following code
while i<5:
print('index value',i)
if prices_df.loc[[i],['low']] < ll:
ll =…
Maged
- 818
- 1
- 8
- 17
0
votes
1 answer
Fill Series with 1m frequency skipping weekends
I have currency quotes in pandas dataframe, column 0 - date/time, column 1 - close price.
And as its a 1 minute period, there are a lot of gaps.
So I need to apply .asfreq(freq='T') on close series, but also I must skip all weekends.
How do I do…
Roman
- 47
- 7
0
votes
1 answer
Most efficient way to generate a random stock ticker in Java?
Im currently working on a personal project that basically creates a bunch of random stock portfolios and goes through them to pick the best one. I am fairly new to Java, so I'm sorry in advance if this is a trivial question.
Basically, the way I am…
Komm Süsser Tod
- 3
- 1
0
votes
1 answer
How to automate the process of acquiring NASDAQ historical stock prices?
I'm trying to get the raw data for 10 year historical daily prices for 200+ different tickers via https://www.nasdaq.com/symbol/aapl/historical. What I'm doing now is searching for each ticker, selecting '10 years' from the Timeframe drop down menu,…
nicoqueijo
- 872
- 2
- 11
- 28
0
votes
0 answers
Group Time Series OHLC Data by chosen period in R
There exist several functions in R in libraries xts and zoo, which try to aggregate financial OHLC(V) data from lower to higher granularities, as well as the newcomer tibbletime::to_period, which performs the same task for a tibble. All of them,…
user3612816
- 325
- 2
- 11
0
votes
1 answer
Power Pivot and Closing Price
I am trying to use power pivot to analyze a stock portfolio at any point in time.
The data model is:
transactions table with buy and sell transactions
historical_prices table with the closing price of each stock
security_lookup table with the…
Power Pivot User
- 1
- 1
0
votes
1 answer
Alpha Vantage stockinfo only collects 4 dfs properly formatted, not 6
I can get 4 tickers of stockinfo from Alpha Vantage before the rest of the DataFrames are not getting the stockinfo I ask for. So my resulting concatenated df gets interpreted as Nonetype (because the 4 first dfs are formatted differently than the…
Excaliburst
- 143
- 1
- 4
- 15
0
votes
2 answers
For Loop in R import multiple CSV from URL
I am importing 500 csv's that have the following similar format:
"https://www.quandl.com/api/v3/datasets/WIKI/stockname/data.csv?column_index=11&transform=rdiff&api_key=keyname"
Where stockname is the ticker symbol of a single stock. I have the list…
user6883405
- 393
- 3
- 14
0
votes
1 answer
Error when trying to download stock price data from Morningstar
import math
import pandas_datareader.data as web
import matplotlib.pyplot as plot
from datetime import datetime
from matplotlib import style
style.use('ggplot')
import csv
with open('sp500const.csv', newline='')…
AlexandrosB
- 133
- 7
0
votes
0 answers
financial chart auto update javascript
I'm currently trying to get better in JavaScript and I decided challenging myself into making a website where you can track a stock portfolio. I have managed to get the chart I want with Chart.js and HTML/CSS, but the challenge now is to have it…
Magsoo
- 1
- 1
0
votes
3 answers
Getting more than 100 days of data web scraping Yahoo
Like many others I have been looking for an alternative source of stock prices now that the Yahoo and Google APIs are defunct. I decided to take a try at web scraping the Yahoo site from which historical prices are still available. I managed to put…
dborger
- 89
- 2
- 5
0
votes
1 answer
Getting Stock Price Data
Now that the Yahoo and Google API is down and it's not possible to retrive stock pricing data from those webistes, what other alternatives are there and how do I go about it?
This is the error I got:
raise…
