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

Get 1st Friday of every month and subsequent day (merging xts objects)

I have an xts object with hourly prices, and want to look at price behavior after Non Farm Payrolls (NFP) economic releases. NFP take place on the first Friday of every month. So I want to create a subset with the prices for the first Friday of…
Krug
  • 1,003
  • 13
  • 33
0
votes
2 answers

Referencing conditions in multiple rows (for loop)

I'm having trouble referencing conditions that take place in multiple rows using a for loop. The idea is as follows. There is a dataframe with columns LastPrice and KCT. Want to add SignalBinary column to the dataframe, and if 1) LastPrice[j] >…
Krug
  • 1,003
  • 13
  • 33
0
votes
7 answers

Financial calculation with JavaScript (What´s wrong?)

I'm trying to make a financial calculation, but there's something wrong. JS Code: function count (){ var coda = 1.500; var codb = 15; var codc = 0.06; var codx = 1; var result =…
Student2792
  • 17
  • 6
0
votes
1 answer

Financial modelling with Pandas dataframe

I have built up a simple DCF model mainly through Pandas. Basically all calculations happen in a single dataframe. I want to find a better coding style as the model becomes more complex and more variables have been added to the model. The following…
Timescape
  • 47
  • 8
0
votes
0 answers

MDX Calendar period vs Financial Period

I need to create a calculated measure on a cube measuring costs in the financial YTD. The dimension available to me has only period values available for the Calendar Period and Financial Period (i.e. 200101, 200102, etc). Example Data in Dimension…
Ivan
  • 1
0
votes
1 answer

Creating Financial statements in sql

Consider the following Tables: Now before I continue I should preface this by stating that I'm not an accountant (which if you happen to be an accountant reading this probably shows!!) I have an invoices table and a related InvoicePayments table…
Dom Sinclair
  • 2,458
  • 1
  • 30
  • 47
0
votes
0 answers

Financial Time Series Matlab

I have a large set of with a matrix given by dataTS1 that is a 1069x25828 matrix. I have stored it as a time series/ financial time series using the fints command from the tool box. I am not exactly sure how to implement a loop to work with this…
PutsandCalls
  • 997
  • 1
  • 8
  • 11
0
votes
2 answers

Calculate subtotal and vat from total amount

I am working on a website for financial calculations. The best practice for valuta is using decimals and no floats so I am aware of it. When all values have been calculated I validate my total, sub and vat. For example: I have the following…
eL-Prova
  • 1,084
  • 11
  • 27
0
votes
0 answers

FinancialFormula.MovingAverageConvergenceDivergence returning incorrect values

I have a series of data and I am calling DataManipulator.FinancialFormula(FinancialFormula.MovingAverageConvergenceDivergence, "12,26", "price:Y3", "MACDHisto"); My problem is that this method should return the difference between the two (12 and 26)…
Mathemats
  • 1,185
  • 4
  • 22
  • 35
0
votes
0 answers

How to change List name dynamically while subsetting in R

I have some publicly listed companies' financial statements in lists with similar structures, already loaded in Global Environment. I want to select a particular element from each list and rbind them in a separate column. For this I have first…
Mithilesh Kumar
  • 256
  • 1
  • 3
  • 18
0
votes
1 answer

Fiscal-year return and standard deviation from daily returns

I want to calculate fiscal year returns and standard deviations from daily returns for a large number of firms. I am relatively new to R, having previously used SAS to calculate returns etc. However, I'd like to switch to R in the short/medium-term.…
Fabian
  • 1
  • 1
0
votes
1 answer

Reshape financial data from wide to long Stata

I have the following data: --------------------------------- |Company | Item | 2012 | 2013 | --------------------------------- | ABD | TA | 100 | 110 | | ABD | EBIT | 200 | 220 | | JKL | TA | 115 | 120 | | JKL |…
Kristo Pherera
  • 9
  • 1
0
votes
1 answer

Need open source standard Financial chart API for asp.net MVC application

Need open source standard Financial chart API for asp.net MVC application. Checked with Google visualization but not reaching financial view standards. Need like this Any else ?
Liladhar
  • 383
  • 5
  • 20
0
votes
1 answer

time value of money - calculating number of periods for each row in a data frame

I'm using tvm from the financial package to try to calc number of periods for each row in a data frame This gives me the correct answer for a single set of inputs: tvm(i=28.99, pv=3929.02, pmt=-167.61, n=NA) and the three lines below throw the…
Chris Hamson
  • 219
  • 1
  • 2
  • 6
0
votes
2 answers

how to make sure the rounding of a floating point number is done only on the first extra decimal position?

I have scanned a large number of questions and answers around math.round /.floor/.truncate/.ceiling but couldn't find a clear answer to my problem of rounding (with currency values). I understand math.round / toeven / awayfromzero but that doesn't…
Herbert
  • 151
  • 2
  • 12
1 2 3
…
23 24