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
1 answer

Different results are obtained with "order by" used in both queries with and without the filtering condition

I want to calculate a specific subset of data from the 1-minute data source in table M_1. Here are my scripts: one=select code,dates, iif(deltas(J)>0,1,0) as J_up from (select * , MACD(close, 5, 34, 5) as `DIF`DEA`MACD`J from M_1 where code="000001"…
YaN
  • 407
  • 1
  • 6
0
votes
0 answers

TypeError: string indices must be integers. While using dataframe

I am just simply getting a stock quote for AAPL using df and I am getting this error. Can someone help me in this matter. I am new to python. #Get the Stock quote df = web.DataReader('AAPL', data_source= 'yahoo' , start= 2012-0o1-0o1 , end=…
0
votes
0 answers

Python Selenium- Loop through HTML Table and click on link

I am trying to Loop through this list of news articles on the html data table and grab all the stories. The only way that seems possible is to click on each title and then it loads on the right side. I can get it to work but when I try to loop…
0
votes
0 answers

Getting Live Feed Data Through NsePy

So I am new to python I wrote a code which gives me spot LTP in a loop. but I wanted it to give me the live data. I want it to give me the live updated data after every 1.5 seconds. Again Sorry I'm New #importing Required Modules from nsetools…
0
votes
1 answer

Financial data api to filter stocks based on queries like market cap

Is there any way to filter the stocks from financial data apis based on specific queries like list of all companies over Market cap of 100 million in amy of the providers currently available? rather to give the specific list of quotes as input…
0
votes
0 answers

The results from using the Skender Stock Indicator Library are returning as memory addresses rather than values, how do I get the values?

I'm using the Stock Indicators module in Python. I've looked at the documentation to determine how to make a Quote, and then use that in the different functions to determine an indicator. It looks a bit like this: import pandas as pd from…
0
votes
0 answers

IMPORTHTML in google sheets

My IMPORTHTML in google sheets to pull in the table from this website keeps erroring out. =IMPORTHTML("https://www.nasdaq.com/market-activity/stocks/fsly/historical","table",1) The document.querySelectorAll("table") shows "0" as the table node but…
0
votes
0 answers

Issues with asynchio while calling AlphaVantage Stock Data API

I need a program that uses asyncio to grab data for multiple stocks from AlphaVantage API. I have tried multiple versions of python and still get errors. api_key = "YOUR_API_KEY" import asyncio from alpha_vantage.async_support.timeseries import…
0
votes
2 answers

How to get data using Google finance API

http://www.google.com/finance?q=nse%3Areliance Is it possible to get real-time data (price and volume) using Google API ? Any sample code (C++/C#) would be very helpful.
Martin
  • 3,396
  • 5
  • 41
  • 67
0
votes
2 answers

Python, requests webscraping - NSE India gives emtpy list

I am trying to use requests to scrape data form NSE to find top gainers on Indian stock market. I have used this same method on yahoo finance and it worked but here, I keep getting the empty list as the result. Here is my code: import requests from…
gasper101
  • 102
  • 1
  • 12
0
votes
2 answers

Google Finance does not show last closing price after market hours. It just shows last *traded* price instead of *closing*

My query is on stock market of India where I fetch the quotes from =googlefinance function in my google sheet. I was very disappointed to know that the function does not show last closing price. Instead, it shows the last traded price. Lets take an…
0
votes
0 answers

ruby requests not able to make connection to NSE india, showing Net::ReadTimeout

url = URI("https://www1.nseindia.com/live_market/dynaContent/live_analysis/gainers/niftyGainers1.json") https = Net::HTTP.new(url.host, url.port) https.use_ssl = true request = Net::HTTP::Get.new(url) response =…
0
votes
1 answer

Pandas grouping and inverting df manipulating of hist.price data

For the following code the output returned is such: The desired arrangement is however with the tickers raised and grouped/aggregated like: All suggestions and feedback welcome. Code sample def prepare_data(symbol, look_back_period): …
0
votes
0 answers

Pandas for .csv creation of hist. price list from FMP-api

Wondering if any experienced pandas users can point me along the way? For the following code, python doesn't accept that df is defined. Output -> "NameError: name 'df' is not defined" It seems like maybe there is a merge and/or replace function…
0
votes
1 answer

DJango channels subscribe to multiple events

I have django application with channels. It opens websocket connection to Crypto-market data provider. I received tick data, I insert those ticks in the database. I also want to send that tick data to other application (say frontend). But I am not…
Rushikesh Koli
  • 23
  • 1
  • 1
  • 6