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
14
votes
5 answers

How to calculate rolling cumulative product on Pandas DataFrame

I have a time series of returns, rolling beta, and rolling alpha in a pandas DataFrame. How can I calculate a rolling annualized alpha for the alpha column of the DataFrame? (I want to do the equivalent to =PRODUCT(1+[trailing 12 months])-1 in…
AP228
  • 333
  • 1
  • 3
  • 6
14
votes
3 answers

Difference between the FIX and FAST protocols?

Could anyone explain what the difference between FIX and FAST? When should one use FIX, and when should one use FAST?
Alisa
  • 305
  • 3
  • 10
14
votes
4 answers

Programmatically access Currency Exchange Rates from Yahoo Finance by Date

I found the answer to this question VERY useful, but I would like to also get exchange rates for dates in the past, not just today's exchange rates. I'm writing an iPhone app that uses the exchange rate to calculate money made from sales in…
Mark
  • 2,666
  • 3
  • 25
  • 29
13
votes
13 answers

How to avoid garbage collection in real time .NET application?

I'm writting a financial C# application which receive messages from the network, translate them into different object according to the message type and finaly apply the application business logic on them. The point is that after the business logic…
Seb
  • 249
  • 2
  • 3
  • 10
13
votes
1 answer

How to fetch the ETF's data into a Google Spreadsheet?

Following this post, where I had listed some of the interesting ETF1s I had found on some of the relevant forums, I received some valuable criticism. Now I want to use a Google spreadsheet to get the updated information of those ETFs in one place,…
13
votes
4 answers

Programmatic API for downloading historical financial statements

I am looking for a web API (free or available at some reasonable cost for an individual developer) to download financial statements for a given stock symbol (income statement, balance sheet and cash flow statements) I searched on this site and found…
serverman
  • 1,314
  • 5
  • 22
  • 39
13
votes
2 answers

Holiday files for G20 countries

For proper financial FX option pricing I require the exact number of business days between two dates. These dates can be up to 10 years in the future, for 2 different countries. I therefore need to know, in advance the holidays for both of those…
Thomas Browne
  • 23,824
  • 32
  • 78
  • 121
12
votes
3 answers

Is there an API for searching Stock Symbols based on Company Names?

This is a similar question to Stock ticker symbol lookup API however that was never answered to the standard I think is needed for a commercial application. The problem is this: Given a company name, partial name, or stock symbol, return a list of…
danpalmer
  • 2,163
  • 4
  • 24
  • 41
12
votes
2 answers

Validate European VAT

What's the best workflow to validate VAT? Currently,we're only using VIES and relative SOAP, but it seems not to be working all that well, as it fails my own VAT number and few others that I know are correct. I'm open to third party, paid services…
Terataz
  • 185
  • 2
  • 2
  • 8
12
votes
2 answers

Parallelize a rolling window regression in R

I'm running a rolling regression very similar to the following code: library(PerformanceAnalytics) library(quantmod) data(managers) FL <- as.formula(Next(HAM1)~HAM1+HAM2+HAM3+HAM4) MyRegression <- function(df,FL) { df <- as.data.frame(df) model…
Zach
  • 29,791
  • 35
  • 142
  • 201
12
votes
5 answers

No definition found for Table yahoo.finance.xchange

I have a service which uses a Yahoo! Finance table yahoo.finance.xchange. This morning I noticed it has stopped working because suddenly Yahoo! started to return an error saying: { "error": { "lang": "en-US", "description": "No…
DolceVita
  • 2,090
  • 1
  • 23
  • 35
12
votes
5 answers

Pandas: Cumulative return function

I have a dataframe such as the following: Index Return 2008-11-21 0.153419 2008-11-24 0.037421 2008-11-25 0.077500 What's the best way to calculate a cumulative return across all columns on the last row? Following is the intended…
Kelaref
  • 547
  • 1
  • 8
  • 26
12
votes
1 answer

Algorithm to determine exchange rate

Given a data set of various currency pairs, how do I efficiently compute the implied fx rate for a pair not supplied in the data set? For example, say my database/table looks like this (this data is fudged): GBP x USD = 1.5 USD x GBP = 0.64 GBP x…
TrevorB
  • 257
  • 1
  • 3
  • 10
12
votes
6 answers

Common strategies to deal with rounding errors in currency-intensive soft?

What is your advice on: compensation of accumulated error in bulk math operations on collections of Money objects. How is this implemented in your production code for your locale? theory behind rounding in accountancy. any literature on topic. I…
Max
  • 1,741
  • 3
  • 23
  • 40
12
votes
11 answers

Using R to Analyze Balance Sheets and Income Statements

I am interested in analyzing balance sheets and income statements using R. I have seen that there are R packages that pull information from Yahoo and Google Finance, but all the examples I have seen concern historical stock price information. Is…
Ramnath
  • 54,439
  • 16
  • 125
  • 152