Stack Overflow
Stack Overflow

Questions tagged [stocks]

313 questions
0
votes
0 answers

SQL Server 2012 Days in Drawdown

I have a table of stock prices: DECLARE @table TABLE (ClosingDate DATE, Ticker VarChar(6), Price Decimal (6,2)) INSERT INTO @Table VALUES ('1/1/13' , 'ABC' , '100.00') ,('1/2/13' , 'ABC' , '101.50') ,('1/3/13' , 'ABC' ,…
Coding_Newbie
  • 365
  • 1
  • 3
  • 11
0
votes
3 answers

Holt Winters For Weekly Volume And Errors In R

I'm trying to use Holt Winters and prediction function for stock index weekly volume from last 10 years, however i am still getting error. Can you help me please? This is what i'm trying to do now: volumen<-read.csv(file.choose(), header = TRUE, sep…
Carol
  • 1
  • 2
0
votes
1 answer

Error: unexpected string constant

I'm getting this error: Error: unexpected string constant in "colnames(dji)[dm[2]] [1] "..11"" when running this command: colnames(dji)[dm[2]] [1] "..11" Basically, the exact same thing is done here, it has all the coding. But with Amazon stock.…
confused d
  • 1
  • 1
0
votes
1 answer

When do today's OHLC prices reflect in googlefinance function in google sheets?

It's 9.30 PM while the market closed at 3.30 PM. Still googlefinance() functions are unable to fetch today's OHLC prices. Yesterday's prices are available though. When do they (today's prices) reflect?
Abhijit Buchake
  • 142
  • 1
  • 9
0
votes
1 answer

Why is my data except for the first column converting to NaN?

I've tried various variations of code including trying to reset_index() because maybe there is a multiindex that is causing the error. If you see the print out below you will notice the 'Symbol' index. I'm not sure how to delete that and whether…
user8851623
  • 722
  • 8
  • 11
0
votes
1 answer

TensorFlow - add variables (weights) constraint

Just a toy example. Suppose we have 5 stocks and we want to find the best portfolio structure (linear weights) maximizing our PnL on history. Weights are used to build portfolio invested in equities. weights = tf.Variable(np.random.random((5, 1)),…
Ainur Kazykhanov
  • 1
  • 1
0
votes
0 answers

SQL statements to store and display records from multiple, joined tables

After a few tries and looking for some answers online, I'm a bit stuck. I'm not sure where, or how exactly I'm supposed to enter the SQL statements and how to make it so that the linker table has IDs from the portfolio and members tables inserted…
Frenzyy
  • 3
  • 3
0
votes
0 answers

Java - Pulling stock price from webpage (HTML)

I am in the process of designing a program, purely out of personal interest and for personal use. I am attempting to extract a stock price for a stock i.e "GOOG" from https://finance.yahoo.com/. I stumbled across a Java class supplied by Princeton…
Brandon Dooley
  • 1
  • 2
0
votes
0 answers

sql How to turn row values into columns in Mysql?

I have got a vast stock data in mysql in the following format... date symbol open high low close volume 2017-11-07 stockA 8.9 8.92 8.88 8.9 68987 2017-11-08 stockA 8.91 8.95 8.9 8.92 …
Ben Tse
  • 1
  • 1
0
votes
1 answer

Solving for the least difference when buying shares and desired portfolio weights

Quick and hopefully easy question. Let's say I'm looking to invest some money in stocks and I've got 5 I want in total, of these 5 I want to invest equally in all of them, 20% of the total capital weight each. the problem being of course that each…
DavimusPrime
  • 368
  • 4
  • 17
0
votes
0 answers

Embeding auto-refreshing element into sharepoint 2013

Guys, is it possible to add an auto-refreshing element (and by saying element I mean simple text) from external webpage? My problem is that i need to embeed an stock price (and only price, without chart)…
Tomek_P
  • 11
  • 2
0
votes
1 answer

Calculate WACC value of stock using api

I am planning to calculate WACC value of stock from API. Please suggest me some free API provider like yahoo finance or help me to derive Weighted average cost of capital(WACC)value from yahoo finance API.Thanks in advance.
Skull
  • 1,204
  • 16
  • 28
0
votes
2 answers

download all S&P 500 companies daily highest market price data

I want to download all S&P 500 companies daily highest market price data like this by R. What is the esiest way I can do that. data would be like this Date MSFT AAPL GOOGL 25-01-05 21.03 4.87 88.56 26-01-05 21.02 4.89 …
Syed Riaz Mahmood Ali
  • 105
  • 2
  • 10
0
votes
1 answer

Using quant package with R to pull daily stock returns using a For Loop

I am a complete beginner. This was an assignment and the goal is to create a For Loop to pull daily stock returns for each of these stocks, starting from 2012 until today. I could get the returns for each year individually by simply pulling those…
Cluracan
  • 1
0
votes
0 answers

How can i transform my existing script to a "one-request-solution" (API)

Calculation of the actual RSI(Relative Strength Index) of the Bitcoin price via API: My script currently makes 14 individual requests to the API to calculate the actual RSI for the Bitcoin. Now I have found a request with which I only have to make…
D.D.
  • 33
  • 4
1 2 3
…
20 21