Stack Overflow
Stack Overflow

Questions tagged [financial]

Anything related to financial calculations and processing of financial data. For example, this tag can be used for questions about interest rates calculations, stock exchange data processing, market data analysis, etc.

Anything related to financial calculations and processing of financial data. For example, this tag can be used for questions about interest rates calculations, stock exchange data processing, market data analysis, etc.

346 questions
4
votes
0 answers

High/low detection in candlestick price chart

I am looking for an algorithm for detecting swing highs and lows from a candlestick price chart with as little lagging as possible. What's observed as a high/low is slightly subjective, but the following figure gives an example (the green bow…
Hyndrix
  • 4,282
  • 7
  • 41
  • 82
4
votes
3 answers

What is the correct way to store payments and refunds in a transaction table?

I have an issue that touches both accounting and database principles. I have a table called Payments that, among other columns has this structure: ------------------------------- id | amount | type ------------------------------- 1 | 100.00 |…
Darshan Shakya
  • 71
  • 5
4
votes
6 answers

Database design question

I accumulated a quite a lot of data in a raw form (csv and binary) - 4GB per day for a few months to be precise. I decided to join the civilized world and use database to access the data and I wondered what would be the correct layout; the format is…
Dani
  • 4,267
  • 4
  • 29
  • 37
4
votes
3 answers

Ecommerce Gems for ROR?

I'm working as a project manager on a site with an Etsy-like shopping cart setup (allowing users to sell their products and taking a small percentage of the sale). While I expect my developer to answer this question, I figure it can't hurt to ask if…
Jack
  • 41
  • 1
  • 2
4
votes
1 answer

What is the most efficient way to get log returns in numpy

What is the fastest and most elegant solution to building a sequence of log returns? The problem is mainly around mapping a function that takes the i'th and (i+1)'th elements as inputs for every element in the array. for a function and simple array…
Alexander McFarlane
  • 10,643
  • 9
  • 59
  • 100
4
votes
1 answer

Kibana weighted average for gross profit margin

I'm currently implementing Kibana 4 (v4.0.0) as a financial dashboard for our company, order data is originating from ElasticSearch. I'm struggling with the absence of a weighted average metric aggregation for calculation of the gross profit margin…
Bamato
  • 41
  • 5
4
votes
1 answer

Go type for purchasing/financial calculations

I'm building an online store in Go. As would be expected, several important pieces need to record exact monetary amounts. I'm aware of the rounding problems associated with floats (i.e. 0.3 cannot be exactly represented, etc.). The concept of…
Brad Peabody
  • 10,917
  • 9
  • 44
  • 63
4
votes
4 answers

Moving average for time series with not-equal intervls

I have a dataset for price of the ticker on the stock exchange: time - price. But intervals between data points are not equal - from 1 to 2 minutes. What is the best practice to calculate moving average for such case? How to make it in Matlab? I…
Victor Mezrin
  • 2,797
  • 2
  • 32
  • 48
4
votes
4 answers

Financial formula for calculating an Adjustable Rate Mortgage?

How can I calculate a fixed payment amount for a loan term that has two different interest rates based on how long the loan has been open?
mdvaldosta
  • 291
  • 2
  • 6
  • 19
4
votes
1 answer

Logic-Free Classes: Code Smell or Ugly System Fact?

I work on an application which, in part, calculates tax bill amounts. A tax bill is comprised of many calculable fields (sheriff fees, clerk fees, penalties, interest, flat rates, etc.) whose mode of calculation is usually static, but may change due…
abarger
  • 599
  • 7
  • 21
4
votes
1 answer

simple financial rate function in javascript

I'm looking for a simple javascript financial RATE function, and I found this one. But it seems too difficult to understand. I want to simplify this function, and I need your help. If anyone has a simplest function, please answer. (It's a excel RATE…
rabugento
  • 73
  • 2
  • 7
4
votes
3 answers

SQL: Creating aging buckets based on last payment date for financial reporting

I need to create an aging report of credit balances on the customer-level. Notes: Aging is based on customer's last payment date. A customer can have multiple accounts, and there are sometimes errors in which a payment is applied to the wrong…
texas_mike81
  • 71
  • 1
  • 2
  • 11
4
votes
6 answers

PHP calculate financial year

I want to calculate the financial year using php to get data from mysql tables. The requirement is to calculate student score in every financial year (31 march to 1 April). Is it possible to make any function that calculates these dates by itself…
Harinder
  • 1,257
  • 8
  • 27
  • 54
3
votes
1 answer

Properly round financial data

I decided to re-create my question: decimal dTotal = 0m; foreach (DictionaryEntry item in _totals) { if (!string.IsNullOrEmpty(item.Value.ToString())) { dTotal += Convert.ToDecimal(item.Value); } } …
user674311
3
votes
6 answers

Financial tracking for software projects

The team I'm part of manage a number of software projects - and most of the stuff we do is end to end, from requirements tracking, to project management to purchasing and setup - a big pain is tracking of financials as we have a whole process to go…
anbanm
  • 13,425
  • 5
  • 22
  • 17
1 2 3
…
23 24