Stack Overflow
Stack Overflow

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
7
votes
5 answers

How Safe Is It To Scrape Stock-Price Information

As far as I can see, there are no developer-API services for stock-price information with the following stipulations: Free or low-monthly cost ( Ability to ship code which uses the service to multiple parties (e.g. an iPhone app) No…
Nexum
7
votes
2 answers

How to convert MetaStock format to CSV?

http://en.wikipedia.org/wiki/MetaStock Anybody knows how to convert metastock data format to ASCII/CSV format ? Any sample code (c++/c#) would be of great help.
Martin
  • 3,396
  • 5
  • 41
  • 67
7
votes
4 answers

Group OHLC-Stockmarket Data into multiple timeframes - Mysql

I need to group stockmarket "1min" data with {Name, DateTime, Open, High, Low, Close, Volume} into different timeframes ie. "5mins/15mins/60mins" on MYSQL. Schema built on sqlfiddle - http://sqlfiddle.com/#!2/91433. I found a link - Group…
Sri
  • 81
  • 1
  • 5
6
votes
1 answer

MongoDB: Schema design for stock tick database

I need to store daily stock closing prices as well as tick data in MongoDB. How would you design such a schema? For daily prices I would be tempted to have one document for each stock symbol, e.g. { symbol: "AAPL", quotes: { { …
Morten
  • 1,819
  • 5
  • 28
  • 37
5
votes
3 answers

Alpha vantage API Not working for NSE while the same query is giving output for foreign stocks

I was trying to get JSON for a company by calling API of alphavantage. For some company data it works and for some company it's failing. For example, for this query it…
S.Roy
  • 61
  • 1
  • 5
5
votes
3 answers

Use T-SQL window functions to retrieve 5-minute averages from 1-minute data

I have a database table containing one-minute periods of Open, Close, High, Low, Volume values for a security. I'm using SQL Server 2017, but 2019 RC is an option. I am trying to find an efficient SQL Server query that can aggregate these into…
Alex Norcliffe
  • 2,439
  • 2
  • 17
  • 21
5
votes
2 answers

R: How do I change gaps (holidays) in a time series of a daily index of the stock exchange by the previous day's information?

I'm usin R language and working with time series daily stock index from differents countries. In order to make comparisons between of differents indexes,(like correletaion, causality etc..) I need that all the series have the same number of lines,…
FlávioCorinthians
  • 115
  • 2
  • 9
5
votes
2 answers

How to differentiate between stock symbols with same name in Google stock API

I am using the following Google rest API to get stock data for a given symbol SYMBOL. https://www.google.com/ig/api?stock= But there are certain symbols like "TCS" which has multiple company names in different parts of the world.eg:…
Rockstart
  • 2,337
  • 5
  • 30
  • 59
5
votes
1 answer

Real Time / High Resolution Stock API?

I'm looking to get my hands on an API (hopefully one that's platform agnostic) that allows me to retrieve real time (or as close to it) equity prices / volume (hopefully). I'm not a professional trader and can't afford anything really expensive…
Aea
  • 976
  • 8
  • 10
4
votes
1 answer

Stock option price variations by users orders (buy/sell)

Following this question Generate a fictitious stock option price variation I wish to simulate that the price change, while users gives an order of buy or sell, like the real stock exchange. (I make a user case to help you to understand.) Initial…
Valky
  • 1,856
  • 3
  • 20
  • 38
4
votes
1 answer

Getting market data from different markets with yahoo and pandas_datareader in python

So I have a bit of an issue with redundant tag names between markets. For example when using the following code to get data: from pandas_datareader import data as pdr from datetime import datetime data = pdr.get_data_yahoo(['AC'],…
kpie
  • 9,588
  • 5
  • 28
  • 50
4
votes
4 answers

page scraping to get prices from google finance

I am trying to get stock prices by scraping google finance pages, I am doing this in python, using urllib package and then using regex to get price data. When I leave my python script running, it works initially for some time (few minutes) and then…
user424060
  • 1,545
  • 3
  • 20
  • 29
4
votes
2 answers

In google sheets, how do you use googlefinance to get the high price of a stock in a date range?

I wrote the following formula, and it only returns the high of the starting date and not the high of the entire date range: =INDEX(GoogleFinance(C7,"high", A7,B7,"DAILY"),2,2) where C7 is the google sheet cell that contains the stock symbol and A7…
Jeff Chen
  • 41
  • 1
  • 1
  • 2
4
votes
3 answers

Fetching technical indicators from yahoo api

I am trying to get RSI indicator from yahoo finance api. so far I can get quote in CSV format, but there seems no api for specific indicator such as RSI. Anyone knows how ? thanks
user1225072
  • 335
  • 1
  • 4
  • 11
4
votes
3 answers

Stock Quotes from Yahoo finance for Indian NSE, BSE

Following is my query using YQL, data is fetched using Yahoo finance, I am using the symbols for the stocks traded on the Indian NSE, BSE http://query.yahooapis.com/v1/public/yql?q=select * from yahoo.finance.quotes where symbol in…
Mrinal Kamboj
  • 11,300
  • 5
  • 40
  • 74
1
2
3
…
19 20