Questions tagged [stockquotes]

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.

289 questions
2
votes
1 answer

Daily stock price changes and price returns per company

I have stock prices in a…
Peter
  • 10,959
  • 2
  • 30
  • 47
2
votes
3 answers

Getting component of stock market index from YQL

Currently, I can get stock quote by returning xml and json using YQL console like select symbol, price from csv where url='http://download.finance.yahoo.com/d/quotes.csv?s=IBM,YHOO,GOOG,MSFT&f=sl1d1t1c1ohgv&e=.csv' and…
morrison
  • 43
  • 1
  • 3
2
votes
1 answer

Partail for-loop in pandas dataframe using datetime

I have 1-min ticker information of Apple in a dataframe as so: Local time Open High Low Close Volume 0 2018-04-19 15:00:00 46.707 46.708 46.687 46.687 0.0150 1 2018-04-19 15:01:00 46.688 46.688 46.667 46.688 …
Aryagm
  • 530
  • 1
  • 7
  • 18
2
votes
1 answer

Does microsoft excel 2016 has function "=googleFinance()" which is available in google sheets?

I want to get the live market price(Indian Market) of some stocks which are already mentioned in my MSExcel sheet, which can automatically update. I saw a function in google sheet (=googleFinance()) that does the same thing. But this function is not…
2
votes
1 answer

Nsetools API's not working when deployed on ec2 instance

I am planning to use nsetools library with python to get top gainers and top losers. the code is working fine on local and getting me all the information but when I deployed same code on ec2 instance the code nse.get_top_gainers() is getting timed…
2
votes
1 answer

Get live data of nse stocks of all symbols in python/Django

I m working on a stock prediction project. This is how I want: To show all the stocks available in Nifty50, Nifty100 or so and then the user will select the stock to predict the high and low price of a stock on next day only. I m using Django. What…
Sandeep Sharma
  • 639
  • 2
  • 9
  • 34
2
votes
1 answer

How to compute Technical Indicators with 1 Minute stock price data?

I am using TA-lib to compute various Technical Indicators. The dataset I have is stock price data for 1 minute intervals. Easiest way is to multiply 390 (390 minutes in a Trading day) with number of days, e.g. To compute 5SMA, SMA(inputs,…
2
votes
1 answer

IEX: Historical market caps

I'm using the IEX api (iextrading.com) and I've found how to get the market cap for a stock (/stock/aapl/stats) and historical close prices (/stock/aapl/chart/5y) but does anyone know how to get historical market caps? I could use the shares…
cliff
  • 49
  • 3
2
votes
0 answers

Ruby On Rails - stock_quote specific date issue

I'm using Ruby on Rails and I'm implementing a library called stock_quote. Using its Github Documentation I've been able to succesfully use the library, using different methods in RoR,…
2
votes
0 answers

How to get TSX stock prices from Morningstar using Pandas Datareader (small-cap stock)?

Since using Google/Yahoo finance gives errors, I'm using Morningstar to get stock data in a dataframe. It works well with common NYSE/NASDAQ stock but is there a prefix/suffix to specify a stock is from the TSX (or other exchange)? import…
Five9
  • 147
  • 6
2
votes
4 answers

Using IEX API for real-time stock info (Yahoo Finance replacement)?

Just like the title says, I'm looking for a replacement source for stock info now that Yahoo has disabled the API many people have been using. The new source I've been looking at is found here: https://iextrading.com/developer/ My question is how to…
Joe
  • 43
  • 1
  • 5
2
votes
1 answer

How to fetch data from Google Finance API post 6th September 2017 for multiple stocks

Post 6th September I am working on a project where I want to display live prices from Google Finance API for multiple stock with information like change change in % volume Timestamp of data and few ratios like ROI/E, ROA, Net-profit-margin -- This…
Shreyansh Lodha
  • 83
  • 2
  • 10
2
votes
0 answers

How to efficiently fill a column of dataframe with values calculated from other dataframes

I am trying to fill a dataframe (elist) with cumulative returns of firms and cumulative market returns. This can be done by looping through the elist dataframe using iterrows, see this link. However, this is slow. I am looking for a more potent,…
Martien Lubberink
  • 2,614
  • 1
  • 19
  • 31
2
votes
2 answers

Examples for Algorithms that can be used for Stock Market Analysis

I was working on a Stock Market Analysis website as a college project. I was keen on knowing some algorithms which I could potentially use for analysing trends in the stock market. I would be glad if some one could help.
Jayesh
  • 3,891
  • 11
  • 55
  • 83
2
votes
0 answers

Source code to google sheets functions

I'm trying to get stock quotes from Yahoo Finance or Google Finance. I know Google sheet's IMPORTXML function can basically do this, but into a spreadsheet. I want to get the price of the stock and then have a program decide to buy / sell /…
Bill Ray
  • 88
  • 1
  • 13