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
0
votes
2 answers

Excel Webservice Function Yahoo Finance

I have the following problem: I use the yahoo finance API with excel to pull stock quotes. This usually works. The function looks e.g. like this: =NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s=MSFT&f=l1")) However, after using this…
Julien
  • 35
  • 1
  • 6
0
votes
1 answer

Stock Exchanges EOD Data conversion program problems

I use National Stock Exchange (India) EOD Data for personal investment decisions. I download the daily End of Day quote file through a software Utility NSE EOD Data Downloader v3.0. The file downloaded is a csv format text file and contains…
skkakkar
  • 2,772
  • 2
  • 17
  • 30
0
votes
3 answers

Where can I get a RSS feed for stock markets?

I am creating a website where people can type in the name of the company and see it's latest stock prices. Where can I get a realtime stock RSS feed? Do I have to pay for it? Thanks for any pointers.
NPXYZ12m
  • 57
  • 1
  • 1
  • 1
0
votes
3 answers

Yahoo Finance API all stocks?

I'm trying to get multiple stock quotes from Yahoo Finance API (http://download.finance.yahoo.com/d/quotes.csv?s=STOCK_NAME&f=nsl1op&e=.csv), but I don't want to mention the stock's name. Is there a way to get the top 100 or 1000 stocks? If not,…
Asaf
  • 8,106
  • 19
  • 66
  • 116
0
votes
1 answer

Spreadsheet importrange high/low during specific times

I want to use importrange to pull in just the high/low data during a specific time of the day, ignoring the rest of the days update. Specifically from 8:30am to 2:50pm weekdays…
Josh W
  • 11
  • 1
0
votes
2 answers

Google Finance JSON does not work with more than 1 symbol

I'm using PHP and JSON from Google finance to get real-time stock updates/quotes using http://finance.google.com/finance/info?client=ig&q=GOOG (this is just an example) My code works fine with above mentioned link (because it only has one stock…
Amit
  • 187
  • 2
  • 15
0
votes
1 answer

Google Spreadsheet ImportHTML and ImportXML: imported content is empty

I am trying to import a table from a webpage into a google spreadsheet. I have tried using the following two functions and both are giving me the error that the "imported content is…
DJL
  • 9
  • 1
  • 2
0
votes
1 answer

ICU Regex text match to work within Workflow for iOS app

First time posting and having an issue with Matching text using ICU Regex. I'm using the workflow for iOS app and trying to create a workflow for stocks using yahoo finance partially because I need to get OTC stock data. From this URL, you…
Jason G
  • 13
  • 4
0
votes
1 answer

CSV text downloading all in one line instead of new lines

I use this code to download the CSV format from Yahoo Finance for a particular ticker. For some reason the CSV file is downloading in the same line as supposed to beginning a new line for everyday in the share price history. Due to this, I am…
bp123
  • 15
  • 1
  • 5
0
votes
1 answer

How to download stock price data only when it is not erroneous (404)?

The script downloads historic stock prices from finance.yahoo.com. An array of tickers is used to loops through the script, creats li´nks based on the ticker array and downloads the data associated to each ticker. However, some of the ticker symbols…
jonas778
  • 75
  • 2
  • 11
0
votes
2 answers

using Excel VBA, given the daily price of 50 stocks, choose 10 stocks such that they have the minumum correlation

The high-level goal is to choose 10 stocks that have the lowest correlation among one another, out of a pool of 50, so that I can have a well-diversified portfolio. I have managed to write some VBA macro to download the past 3 years of daily price…
correl
  • 1
  • 2
0
votes
1 answer

Excel 2013 record/refresh live stock data

I am working in Excel 2013 trying to record live stock data from Yahoo Finance. In my cell A1, I have the GoPro stock symbol GPRO. Cell B1 has the code =WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s="&A1&"&f=l1") To get the live stock price…
Chris
  • 39
  • 2
  • 4
0
votes
1 answer

Google Finance API Not Consistent

I'm writing some software to do charting and analysis of intraday stock data, and so far the only free (or even affordable) feed I've found which gives 15 minute data for the past week or so is Google Finance. But something I've noticed, which I…
Sean Duffy
  • 199
  • 6
0
votes
1 answer

Nestl Historical data are missing in yahoo finance

I am looking for historical data of different companies. I am using Yahoo Finance to acquire data and plot them in candlestick chart using matlab software. However i have noticed that yahoo finance only provides some data. For example data from…
user3290332
0
votes
1 answer

URL expiry parameter for retrieving option chains from Google

http://www.google.com/finance/option_chain?q=AAPL&output=json This URL returns the immediate expiry AAPL option chains from Google. What is the tag to add to the URL to get an option chain with a different expiry? In YQL, you can use "m=2015-01",…
user3411827
  • 11
  • 1
1 2 3
…
19 20