Stack Overflow
Stack Overflow

Questions tagged [stocks]

313 questions
0
votes
0 answers

Yahoo finance library - get list of FTSE 100 companies

Is there a way to get the list of the entire current FTSE 100 companies using Yahoo finance in Java, perhaps into a String or an array?
Rpp
  • 103
  • 1
  • 12
0
votes
2 answers

Parsing JSON and loading into array

JSON-https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=MSFT&apikey=demo I am trying to take the JSON from the above link and place it in the following…
Michael
  • 103
  • 1
  • 11
0
votes
1 answer

stockSymbols quantmod errors with hyphens with google

the R package, Quantmod seems to have trouble accessing companies from Google when using the stockSymbols() function. Here's a list of the companies I'm after from the NYSE, it's just the first 30: NYSE [1] "A" "AA" "AAC" …
DavimusPrime
  • 368
  • 4
  • 17
0
votes
3 answers

Financial Statements pasting next to old one

So here I have a vba code that populates financial statements for different companies, when I first run the macro it pastes the information from columns B to G, yet when I re-run it, it will paste to the right of the old data in columns H to M and…
Sebastian
  • 13
  • 2
0
votes
1 answer

Python dictionary not working when combined with additional entries

I am attempting to make a Python program that does the following: Given a list of tickers (stock symbols), form a list of links associated to each one at the website www.thestreet.com, to find their Analyst Rating. Then, (this is using the Mechanize…
Jacob A
  • 109
  • 1
  • 10
0
votes
0 answers

Get values from the Yahoo Finance source-code

I am following this tutorial (Python) by Sentdex in which we are now supposed to find/get certain values off of the Yahoo Finance source code. In the tutorial (recorded 2013) measures, such as price/book ratio, include their value in the same line…
Newman
  • 147
  • 1
  • 5
0
votes
1 answer

Python Pandas search by hour on multiple index

I have a multi index pandas array and I am trying to find the Minimum and the Max between the 9:30~10:00 Am. I could iterate the array and check if the times match or not. But it should be a way via pandas... Is there a way to group/search the 30…
Erick Gomez
  • 83
  • 1
  • 1
  • 6
0
votes
1 answer

SQL Change Column header to value from another column

I am trying to pull price data for multiple stocks. Everything is in columns, including the tickers to when I try to pull data for more than one stock I can't figure out how to have the ticker in the column header for each stock. The below code…
W Rogers
  • 3
  • 1
0
votes
0 answers

python/pandas/stock/forex - Iterate over multiple time frames

How do i iterate over the '1Min' and get the previous '5Min' value? 1Min 5Min IndexX 2016-01-03 23:00:00 5 100 2016-01-03 23:01:00 6 NaN 2016-01-03 23:02:00 7 …
john
  • 13
  • 3
0
votes
1 answer

getSymbols.yahoo - unable to get the latest price for several hours after trading closes

I use getSymbols.yahoo to get a time-series of a stock price. I usually set some starting point in the past (lets say a date a year ago) and always the latest possible price from the last trading day. Everything works fine but for one thing. If I…
Pat Amat
  • 23
  • 7
0
votes
2 answers

Looping from 5th to final worksheet in vba?

I have 35 to 40 worksheets with daily stock data and I am trying to calculate the stock returns for each worksheet in a macro. The formula is: LN(Today/Yesterday) which gives the daily stock return. I am running the code below but I cannot figure…
Nick Garcia
  • 29
  • 1
  • 1
  • 7
0
votes
1 answer

How to get total of highcharts multiple series

With the Highcharts value-in-legend plugin http://www.highcharts.com/plugin-registry/single/10/Value-In-Legend, I have been able to kind of implement a sort of multiple series total, but I do not understand how to get a total for a clicked y-axis…
imparante
  • 503
  • 9
  • 21
0
votes
1 answer

Pyalgotrade - TA-LIB - Indicator Returns "NONE"

I'm working with Pyalgotrade to test a trading strategy in python. Pyalgotrade allows for the use of a library called TA-LIB,which is a technical analysis library. For some reason, when I use the PPO indicator it returns "None". The indicator takes…
RageAgainstheMachine
  • 901
  • 2
  • 11
  • 28
0
votes
0 answers

Neural Net MSE trough

I am trying to train a BackProp Neural Net with 21 inputs and 1 output. The input data is S&P 500 stock data (indicators) and the output is if a buy should occur. I have tried a number of neural net configurations but as the epochs progress the MSE…
Mike Smith
  • 39
  • 1
  • 3
0
votes
1 answer

Calculating the stock price volatility from a 3-columns csv

I am looking for a way to make the following code work: import pandas path = 'data_prices.csv' data = pandas.read_csv(path, sep=';') data = data.sort_values(by=['TICKER', 'DATE'], ascending=[True, False]) data.columns I have a 2 dimensional array…
Spurious
  • 1,903
  • 5
  • 27
  • 53
1 2 3
…
20 21