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

quarter to annual dplyr financial years

I'd like to aggregate some data from quarterly to annual, based on financial years. So the year would cover September to June. I can manage to aggregate over the year, but it is calendar year aggregation. An example below: Date <-…
Adam_123
  • 159
  • 9
0
votes
1 answer

How to functional test and automate a spring batch java application?

We use spring batch in our java based application (financial banking application) and I'm looking for a good tool to test functionality including job level functionality using automation(also needs CI integration). The goal is to run the batch jobs…
Jithu Paul
  • 154
  • 2
  • 15
0
votes
1 answer

Price in decimals to Price in 32nds

I'm trying to code a function for this : a conversion from Price in decimals to Price in 32nds : Like this calculator : http://www.iotafinance.com/en/Fractional-Decimal-Price-Conversion-Calculator.html I code a function in PHP but this not working…
Flatbeat
  • 123
  • 1
  • 3
  • 13
0
votes
0 answers

Crystal Reports 2011 Multiple outputs of currency

I am trying to write an output based on multiple part numbers that will display multiple price outputs. Ive used if {ItemCode}="XXXX" then $220.00*{Quantity} But I have about 4 different item codes and pricing outputs I need to display. Ive tried…
Steve
  • 1
0
votes
2 answers

How to calculate compound interest by days?

I am writing a Java application to calculate interest. The formulas for Simple, Compound, and Continuously Compounded interest use years to calculate the amount accumulated, but I want to use days so that my software updates more frequently. What…
Scooter
  • 86
  • 2
  • 10
0
votes
1 answer

Variables in financial time series

I'm currently trying to do some forecasting with financial time series in R. I've started to do a linear regression where the dependent variable is the excess return calculated for 1, 12, 24, 36, and 48 months. I've calculated ln(r1/r0) for 1-month…
Stephane
  • 29
  • 1
  • 3
0
votes
1 answer

R Studio: work on PDF file or HTML file to extract informations

I'm looking for a way to work on a PDF file (or using a direct link). I have to work on file PDF file to extract information about a companies financial statements and I desire to work on the file directly. Is it possible? Have i to transform the…
Matteo
  • 1
0
votes
3 answers

Financial Statements pasting next to old one

So here I have a vba code that populates financial statements for different companies, when I first run the macro it pastes the information from columns B to G, yet when I re-run it, it will paste to the right of the old data in columns H to M and…
Sebastian
  • 13
  • 2
0
votes
1 answer

Transforming Calendar Quarter to Financial Quarter

I am working with a dateframe (INPUT) that contains number the of transaction of a product per calendar quarter. The first column (DATE) contains the calendar quarter in this format "2016 Q2". I would like to transform this date into the a…
FFB
  • 255
  • 2
  • 7
0
votes
1 answer

Accounting system, bank emulator

Do you know any accounting system emulator, that could be used free? The following requirements should be met: defining accounts and currencies for them handling balances provide simple transfer functionality keeping payment history and let you…
Gábor Lipták
  • 9,646
  • 2
  • 59
  • 113
0
votes
0 answers

Python pyalgotrade Quandl feed Error

having an error with feed.addBarsFromCSV when combined with quandlefeed as below and used on instrument "CBOE/VIX" import quandl as qd from pyalgotrade.tools import quandl from pyalgotrade.barfeed import quandlfeed name = '%s.csv' sym = "VIX" data…
stats999
  • 43
  • 1
  • 3
0
votes
0 answers

numpy.irr returns error: ValueError("Input must be a rank-1 array.")

Im trying to calculate the IRR of a monthly savings plan using the numpy.IRR function. I keep getting an ValueError("Input must be a rank-1 array."). How can I turn my array "Cashflow" into an array that does not yield this error? I have tried…
user7364339
  • 1
  • 1
0
votes
1 answer

How to calculate Trailing Moving Sums going up vertically in a table?

I have the following table: Table Columns 'L' and 'U' if the table consist of cells that contain object names that correspond to the headers in columns 4-281. Example Goal: For every date verify what objects are in 'L' (respectively 'U') and sum the…
John
  • 71
  • 7
0
votes
1 answer

Retrieve data 'quantmod' package

I am trying to retrieve the SP500 data with: SP500 <- getSymbolsundefined"^GSPC", from ="2000-01-01", to = "2016-08-31", auto.assign = FALSE) But I got the following error: Error: unexpected string constant in "SP500 <-…
José
  • 189
  • 7
0
votes
1 answer

Coding New Trading Indicator

I have a piece of code (below) that I am trying to correct. The goal is to check if there have been 7 consecutive positive days (close is higher than open). We will then place a binary value on the 8th day if this is true i.e. 1 if it is True and 0…
DDR
  • 81
  • 2
  • 4
1 2 3
…
23 24