Questions tagged [finance]

Finance relates to the management of assets over time under varying conditions, usually in order to make a profit.

Introduction

Finance relates to the management of assets over time under varying conditions, usually in order to make a profit.

The finance (or "financial services") industry is an umbrella term for organisations that manage money & assets. It includes businesses like banks, credit card companies, insurance companies, consumer finance companies, stock brokerages, hedge funds and investment funds and some government sponsored enterprises.

These businesses are usually subject to government regulation, often rely on global standards and interact with each other through purely electronic markets. They employ many thousands of programmers who often turn up common programming problems.

What questions should have this tag?

Programming problems specific to the finance industry, such as:

  • financial messaging standards & protocol implementations (e.g. FIX or SWIFT)
  • domain models/patterns for accounting, currency, trading & brokerage, etc.
  • application of programming techniques to financial businesses & problems (e.g. risk management, pricing, trade netting, etc.)
  • low latency, high volume/frequency trading systems
  • implementation of common mathematical problems (e.g. time value of money, compound interest, etc.)
  • management and processing of market data
  • regulatory issues as they relate to systems programming

Other relevant forums

Questions which have more of a financial background than a programming background should rather be asked at quant.stackexchange. In particular, this tag should never be used on its own but rather in combination with a programming language.

2470 questions
0
votes
1 answer

Partial admin automation in excel

I'm trying to make an excel expression that would automate the numbering of the types of financial transactions my school business makes. There are three types; "PPD", "VPD", and "VBU". As you can see in the picture below, each type has to be…
0
votes
1 answer

Comparing daily returns of every stock with S&P500 and sort the most which overperformed

I need to -download all the historical prices of every stock contained in the S&P500 and the historical price of the index -calculate the daily returns -comparing every daily returns of every stock with the daily returns of S&P500 -sorting a list of…
0
votes
1 answer

getQuote "what" possible fields in Quantmod (R)

I am trying to find the "1y target Est" from yahoo finance with getQuote using the Quantmod package but it doesn't seem to be working. Does anyone have more info about this? I can't find much in the documentation. Or maybe another function/package…
DDigits
  • 127
  • 6
0
votes
1 answer

Optim function in R

my colleagues and I have an assignment to submit with the following directions: Without using any built-in R functions, write a general function that estimates a GARCH(1,1) for a time series, and that returns the parameters, standard errors and the…
fcm
  • 1
  • 1
0
votes
0 answers

C#: Natural Log needed with decimal values for financial purpose

Is there a way to compute a natural log using decimal values in C#? I need something like decimal dec = Math.Log(decimalInput);` The problem is that Math.Log(x) only works with a double type as input and another double as output.
0
votes
1 answer

Creating a new column based on the difference of another column

I have a dataframe as below: d = {'col1': ["A", "A", "A", "B", "B", "B"], 'col2': [2015, 2016, 2017, 2015, 2016, 2017], 'col3': [10, 20, 25, 10, 12, 14]} I would like to get the difference of col3 by col1 and col2. Such that, col1 represent…
hilo
  • 116
  • 11
0
votes
1 answer

In Excel Has Data in a Cell that is linked to Google Finance have extra information that interferes with code for range.value?

I have a cell that is linked to Google Finance Stock Ticker. It replaces the Ticker with the stock name and a link (bank icon) included that brings up more data. I wish to have the stock name be added to a range cell using .value or value2. but I…
geddeca
  • 119
  • 1
  • 1
  • 9
0
votes
1 answer

Struggling to change y-axis in Monte Carlo from number of occurrences to percents

I am trying to change my Y-Axis on a histogram I have created for a Monte Carlo Simulation. The Y-Axis is currently outputting number of occurrences opposed to percents. I have my code below and I am assuming there needs to be a function with "For Y…
0
votes
1 answer

WEBSOCKET Financial data: Errno 22 in datetime

I have a WEBsocket that works fine, and have been working with websockets before with no problems. Im drawing data from Bybit API but i just cant seem to parse the timestamp correctly, any ideas on how i can fix this, or point me towards direction…
0
votes
1 answer

How do I get the raw data behind this WSJ

I'm looking at http://online.wsj.com/mdc/public/npage/2_3051.html?mod=mdc_h_dtabnk&symb=DJIA#IndexComponents and wondering if there is a way to get hold of the data that wsj is showing, preferably without breaking the law to much. I'm trying to…
0
votes
0 answers

Put variable in Yfinance with Python

Good evening everyone, Small question ... I use Python and in particular the y.finance library (Yahoo Finance) which allows to extract financial data. When using this package, an expected format is predefined. It should be like this:…
0
votes
1 answer

Financial Data Analysis with Python

I would like to perform data analysis. Indeed I would like to analyze the potential correlations between the price of CAC40 and Bitcoin. For that I did data scrapping and I was able to import the values of CAC40 and Bitcoin over the last two years.…
0
votes
2 answers

I want to save the mean (by row) of different set of dataframe columns and store them in a new dataframe

For doing so, I have a list of lists (which are my clusters), for example: asset_clusts=[[0,1],[3,5],[2,4, 12],...] and original dataframe(in my code I call it 'x') is as : return time series of s&p 500 companies I want to choose column [0,1] of…
Farhad
  • 1
  • 4
0
votes
0 answers

I am trying to organise this code to test over multiple stocks

I am trying to formulate a code that tests for optimal MA's on a list of stocks. I have a working code for one stock that simply returns a one line DF with the best result, but I am struggling to try and create a code that runs for multiple socks. I…
Ben
  • 25
  • 2
0
votes
1 answer

Bloomberg Excel API for Hourly Volume Data

I'm trying to download hourly trading volume data via the Bloomberg Excel API. For context, this is the formula I'm using, which pulls hourly trading data for Apple between Dec. 10, 2021 and Dec. 17, 2021: =BDH("AAPL US EQUITY", "VOLUME",…
lithium123
  • 87
  • 1
  • 9