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
0
votes
1 answer

Storing many historical variables in different tables but mantaining same Variable Names

I have an Excel file containing the time series of some financial variables, let's call them X and Y, computed at the same dates. These variables are computed for four different universes of funds, let's say A,B,C and D, which are all made of 6K…
Francesca
  • 13
  • 2
0
votes
1 answer

PHPExcel based function RATE() returning incorrect value

The newest version, found here: https://phpexcel.codeplex.com/SourceControl/latest#trunk/Classes/PHPExcel/Calculation/Financial.php of the RATE() function is not working for me. I created a new PHP page, cut out that specific function and tested it…
Patrick
  • 5,442
  • 9
  • 53
  • 104
0
votes
1 answer

Is there a way to check digits of a CUSIP in Perl

My work place won't allow us to install any modules so that option isn't for me. So decided to look at this link http://en.wikipedia.org/wiki/CUSIP and follow the pseudocode there and attempt to code it in Perl. And i came up with the…
user2025696
  • 159
  • 1
  • 11
0
votes
1 answer

Query aggregated data with a given sampling time

Suppose my raw data is: Timestamp High Low Volume 10:24.22345 100 99 10 10:24.23345 110 97 20 10:24.33455 97 89 40 10:25.33455 60 40 50 10:25.93455 40 20 60 With a sample time of 1 second, the output data should be as following…
newBike
  • 14,385
  • 29
  • 109
  • 192
0
votes
1 answer

Calculating IRA/retirement with Python from user input

The code below, albeit somewhat messy, asks the user to input their: years until retirement, interest rate, initial amount, and amount added each year. That part works fine. What I am trying to do now is calculate the value every five years based on…
Ben
  • 95
  • 1
  • 4
  • 16
0
votes
2 answers

How To Compute Maximum Monthly Payment

(NOTE: Although this question refers to a spreadsheet to solve the problem, I am also open to using PHP or Javascript) I have a spreadsheet for forecasting my personal financial budget for the next 3 years. The goal is to pay as much as possible on…
ThinkCL
  • 119
  • 3
  • 12
0
votes
3 answers

Finance Times Series - SQL Server - Extract Ordered Data from multiple columns when some columns are NULL

Imagine the following financial trade and quote data in an MS SQL Server table called "tblPrices". SeqNo Ticker TradeType JulianTime Price BidPrice AskPrice 1 CLK4 Quote 735706.11 NULL 103 …
Dr Ian Gregory
  • 1
  • 1
0
votes
1 answer

Build Back Adjusted Continous Futures contract from Historical Data

I am learning Python, so need direction on how to approach this problem. I am using the Quandl package to download historical futures data (ESH2000, ESM2000, ESU2000, ESZ2000, ESH2001, ...., ESU2014). Now I want to build the continuous back…
Snoopy
  • 53
  • 2
  • 7
0
votes
1 answer

Converting MS SQL float row, rounding to 2 decimals, may we use MS Access for rounding?

We have a legacy financial application running which is no longer supported but important to us. We have overwritten approximateley 250 rows manually in 2 columns "price" and "selling_price" and now the application crashes at some point where it…
Alojz Janez
  • 530
  • 1
  • 3
  • 13
0
votes
3 answers

Php financial XIRR not giving strange results

I'm using the XIRR function from the php financial library (http://www.phpclasses.org/package/892-PHP-Financial-functions-with-the-Excel-function-names-.html) but I get strange results with these values (dates are d/m/y): (01/01/2014, -400) ,…
gonel
  • 1
  • 2
0
votes
0 answers

Converting Financial Duration function in F# to C#

I have been tasked with migrating some specific Financial functions written in F# to C# The F# library I am using is excellent (http://archive.msdn.microsoft.com/FinancialFunctions) but environmental considerations prevent the deployment of a CLR…
Steve_at_Industrial
  • 9
  • 1
0
votes
3 answers

Compound interest with deposits in Python

I am working on an assignment for a comp sci class. I feel like I am really close but I cant quite get to the answer. Basically the assignment is a compound interest calculator, what I am trying to do that makes it more complicated is adding…
user3268414
  • 1
  • 1
  • 1
  • 1
0
votes
1 answer

Matlab - Why doesn't this comma-separated list work as input parameter?

I have a mxn financial time series object (fints) called data. Now I'd like to merge each of its n series into a new fints by keeping only the intersecting dates (the series headers are all unique). Here's what I do: headers = fieldnames(data,1); …
bluebox
  • 555
  • 1
  • 8
  • 19
0
votes
3 answers

Annotations for the future on the candlestick chart

I have script which draw candlestick chart. I added two annotations to this script. One is "Last data" which show last candle and the second annotations should show point in the future. But for some reason it is not visible on the picture. How can I…
Adam
  • 2,254
  • 3
  • 24
  • 42
0
votes
2 answers

Using decimal outside the finances

I always hear that floating point suffers from rounding errors and, therefore, decimal types must be used in place of the floating point for the finance. What do they mean by finance? Do they consider money alone whereas gold, copper, iron, honey,…
Val
  • 1
  • 8
  • 40
  • 64
1 2 3
…
23 24