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
1
vote
2 answers

SEC/Edgar Prospectus Filings

I am trying to develop a routine that monitors the SEC database (EDGAR) for new mutual fund filings resulting in a "Prospectus". The SEC filing type 485BPOS is supposed to represent a new prospectus filing, or an amendment to a prospectus. I am…
Todd Peterson
  • 83
  • 1
  • 5
1
vote
0 answers

mobile application handling sensitive data

I was asked this question by a friend of mine and was wondering if anyone might have an answer to this. Given you have a mobile application that handles sensitive data and financial transactions, and that the application must work on 25+…
1
vote
3 answers

XNPV calculation in C# or VB without using excel

Has anyone developed a financial function XNPV? I am looking for code that will calculate this value. I am not looking to call excel to calculate the value. Any help would be great, thanks
Dijon Smit
  • 13
  • 4
1
vote
2 answers

XML standards for financial SOAP-based web-services

I'm developing an XSD scheme for SOAP-based web-service that provides financial calculations. Service response contains historical performance of portfolios of investments and different measures: rates of returns, standard deviations etc. I'd like…
Andrey
  • 3,667
  • 6
  • 27
  • 36
1
vote
1 answer

Read millisecond tick data without decimal point format to zoo series

I'm trying to read some CSV-format financial tick data (source: HISTDATA_COM_ASCII_EURUSD_T_201209.zip) into a zoo series. The data is indexed by a time column which contains timestamps formatted such as 20120902 170010767 - almost like %Y%m%d…
mchen
  • 9,808
  • 17
  • 72
  • 125
1
vote
4 answers

How do I implement a real time *financial* statistics engine from SQL server data for dashboard display?

We currently use excel automation to calculate time series statistics and store the results in our SQL Server 2008 database for easy display/sorting/etc. later. I'm currently redesigning the home screen of our app to present the most important…
GollyJer
  • 23,857
  • 16
  • 106
  • 174
1
vote
2 answers

PHPExcel based function RATE() returning NAN()

I have this code: http://pastebin.com/Sd9WKZFr When i call something like rate(60, -6000, 120000) it returns me a NAN result, but the same function on MS Excel returns me 0,04678.... I have the same problem trying -5000, -4000, -3000 and…
sdlins
  • 2,195
  • 1
  • 23
  • 31
0
votes
1 answer

Stock Beta through API (Preferably in C#)

Anyone know how to get a stock's Beta through an API? (Preferably in C#) I know it's available on Yahoo/Google/Reuters/Bloomberg when you go to their website, but it seems like none of the YQL / Google Finance stock API / other interfaces support…
user1167650
  • 3,177
  • 11
  • 34
  • 46
0
votes
3 answers

A efficient way to store formula to calculate financial reports?

We are developing a system that will do financial statements and other financial-related things. We are developing the app in Java/Java EE, specifically in JBoss Seam (Richfaces, a4j) + Javascript and other technologies. Now we have a lot or…
0
votes
3 answers

future value calculation not returning expected result

have the following FV function private static function fv($r,$n,$p,$pv=0) { $sum = $pv; for ( $i=0;$i<$n;$i++ ) { $sum += ($sum * $r) + $p; } return $sum; } These are the values I'm passing in: 0.0067 444 1834.58 This is the…
Mina
  • 610
  • 7
  • 21
0
votes
1 answer

Is there an NPER or financial function library available that supports NPER functions?

I've been scouring the internet for the better part of two days looking for a JAVA financial library that has functions similar to Excel's, particularly NPER. the closest thing I've come to is the one here:NPER formula, except when I type that…
Evan R.
  • 1,210
  • 1
  • 27
  • 42
0
votes
1 answer

Library for stock options calculations

I am writing some financial analysis software and need to do some calculations concerning stock options. I need to calculate the current value of a short position if it were closed by selling, by getting exercised, or by expiration. However, I do…
User1
  • 39,458
  • 69
  • 187
  • 265
0
votes
2 answers

Storing/Creating User Profiles

I've been looking for a way to store user specific data, the data needs to be securely stored so only the user who knows their username and password can access the data. Each profile will have financial data stored against them and they will have to…
user863551
0
votes
2 answers

SQL Server & C# immediate notification to client when database updates with millisecond timing

I'm still writing my financial software :P And have finally gotten a reliable real data live data feed which I am currently storing into my SQL Server database in real time. As in the stock market, timing is everything, I am wondering how I would…
DeveloperDavid
  • 157
  • 2
  • 7
  • 16
0
votes
2 answers

How would I write the formula for compound interest in an expression in Java?

So far I have double futurevalue = moneyin * (1+ interest) * year;
Aaron
  • 11,239
  • 18
  • 58
  • 73