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

How to group financial time series objects in Matlab

I want to group 2 or more financial time series objects of different length. Specifically, I have FTS a and b, a is shorter than b, and how can I get a time series c, so that c has two sub series a and b, and all the missing records in a is filled…
Shuai Hou
  • 1
0
votes
1 answer

Draw market chart bar using R

I need to draw market profile (aka volume profile) chart in R. Above is an example of what I want. Horizontal axis is date. On the vertical axis I have level. And I also need to have horizontal bar at every date and every level that shows volume…
Dmitry Astretsov
  • 1
  • 2
0
votes
1 answer

Project revenue calculation in DAX

I need to calculate the ongoing revenue for installation + maintenance for projects and calculate the monthly revenue for controlling purposes in DAX in Power BI. The problem is the following. The projects are stored in a table CONTRACTS like…
Garamvölgyi Mihály
  • 79
  • 6
0
votes
2 answers

DateAdd and DateDiff for Financial Week number and Year

I have seen and used various forms of DateAdd and DateDiff to strip time, get to the first day of any month or to move around a date. I can see that when performing these calculation a pattern often used is as below: select DATEADD(m,…
Unbound
  • 177
  • 2
  • 14
0
votes
1 answer

R: finding percentages with time series data

I am working with financial data on R and I need to know what is the percentage of days with a stock return larger than 5% in absolute value. I have the variable "returns" and my intuition is that I should create another variable for which the…
wlog
  • 25
  • 3
0
votes
1 answer

Import data csv with particular quotes in R

I have a csv like this: "Data,""Ultimo"",""Apertura"",""Massimo"",""Minimo"",""Var. %""" "28.12.2018,""86,66"",""86,66"",""86,93"",""86,32"",""0,07%""" What is the solution for importing correctly please? I tried with read.csv("IT000509408=MI…
mattew89
  • 11
  • 3
0
votes
1 answer

Working with accurate currency values in Javascript

I'm working on a system that uses financial data. I'm getting subtle rounding errors due to the use of floating point numbers. I'm wondering if there's a better way to deal with this. One of the issues is that I'm working with a mixture of different…
Evert
  • 93,428
  • 18
  • 118
  • 189
0
votes
2 answers

Tomcat is not starting after installing Mifos on Windows using Xampp. Mifos doesn't work, what is wrong?

I am trying to install Mifos in Windows 10 using Xampp 5.6.8. I tried all the steps given in Mifos documentation but now Tomcat server does not start. What did I do wrong?
kasun kalhara
  • 1
  • 1
0
votes
1 answer

PMT function excel formula when the rate is zero

Im tryng to do in SQL Server a Function with the PMT function found in MS Excel. And when i use in excel =PMT(0;3;-29590) give me this result: $9,863.33 And when i try any formula, give me divide by zero error. and i have some paiments in 3…
Luis Molina
  • 3
  • 2
0
votes
2 answers

how to calculate PMT function(financial function) on blockChain solidity

how do I convert this code (javascript code) into solidity code and it will work? function pmt(rate_per_period, number_of_payments, present_value, future_value){ if(rate_per_period != 0.0){ // Interest rate exists var q = Math.pow(1 +…
Nicholas Brodoviz
  • 95
  • 1
  • 1
  • 7
0
votes
2 answers

SciPy optimization - args in constraint function

I am trying to build a portfolio optimization algorithm that minimizes Expected Shortfall (CVaR) subject to weighting boundaries and return constraint. While it already works without minimum return requirement, adding return constraint results in…
Diogenas
  • 1
  • 4
0
votes
1 answer

(Python/JSON/MySQL) Advice on financial data in JSON that won't transfer to db

I have a JSON file with raw financial data, including OHLC, volume, trades, etc. All of the data except the OHLC will correctly transfer to the MySQL database I setup. The OHLC data only as zeros after the transfer to the database. The raw json data…
Mikey Mike
  • 79
  • 1
  • 9
0
votes
1 answer

How to write a formula to calculate tax dynamically

I have an income statement projection sheet and I attached one part of it below. I have a question for the yellow line (Row 7). I try to find a formula to calculate the tax based on Row 5. The logic is: for any cell (cell X7) between H7 to R7, if…
emma12345
  • 107
  • 4
  • 10
0
votes
0 answers

Storing Stock OHLCV Data into Their Own Lists (Python)

I'm trying to store stock data (Open, High, Low, Close, Volume), pulled by pandas_datareader, into 5 distinct lists named accordingly. I am new to Python and am wondering where I am going wrong. I got it to cycle through a one-dimensional list of…
Golightly
  • 3
  • 6
0
votes
1 answer

Bloomberg Terminal Screener for HQ Location with Revenue Sort

How do I build a screener for the Bloomberg Terminal that let's me identify a list of headquarters by state and sort by revenue?
Jacquelyn Renée
  • 13
  • 2
1 2 3
…
23 24