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

Find equivalent interest rate for cash advance fee + promo rate

I take a cash advance of 'amount' from my credit card, paying an up-front 'fee' (given as a percentage), with a promotional rate 'int' for time 'len'. I must pay at least 'min'% of the owed amount monthly. I put 'amount' into an investment…
user354134
1
vote
1 answer

Truncated DECIMAL values in mysql (30 decimal places)

I'm currently using LOAD DATA LOCAL INFILE to import bulk financial data for processing. The values within the file are stored to an accuracy of 30 decimal places, e.g. 125.154821679413246187945612314846 When this imported however, the data is…
locksem
  • 315
  • 3
  • 16
1
vote
0 answers

How to use Plaid API to access bank transactions?

I'm very much a beginner with iOS and the Plaid API, and I'm looking to make a budgeting app that collects users' existing bank transaction data using Plaid. I've currently successfully integrated bank account login with Plaid, but haven't been able…
user6335453
  • 135
  • 2
  • 7
1
vote
0 answers

Financial Year calendar generation with date and month limits

i've been working on Financial year calendar and it is also generating year correctly but the problem i'm facing is i want to restrict this with date like right now its generating current and next Financial year but i want to give custom date with…
Salman Khan Sohoo
  • 97
  • 1
  • 1
  • 13
1
vote
2 answers

How to determine the difference in quarterly row values of a pandas dataframe when quarters are missing

I am trying to find the difference in quarterly balance sheet equity values from the following data frame: import pandas as pd import numpy as np df2= pd.DataFrame({'FirmID' : pd.Series(['ID001', 'ID001', 'ID001', 'ID001', 'ID001', 'ID001',…
Martien Lubberink
  • 2,614
  • 1
  • 19
  • 31
1
vote
0 answers

What are some algorithms & data structures useful for aligning (financial) asynchronous systems?

I'm auditing some financial data between two transaction systems. The two datasets consist of lists of transactions. Each has, timestamp, idiosyncratic transaction IDs (not shared between systems) transaction values (item names, item values,…
xtian
  • 2,765
  • 7
  • 38
  • 65
1
vote
1 answer

I am trying to add Rahul Mohindra Oscilator to R

I am beginner in R and recently trying to create a algorithm for trading (quite challenging) and do a backtest. The thing is TTR and Quantmod do not have the function I need so I tried and create it. So I found the function in a website but is no in…
Kylian
  • 59
  • 7
1
vote
1 answer

Python - select certain time range pandas

Python newbie here but I have some data that is intra-day financial data, going back to 2012, so it's got the same hours each day(same trading session each day) but just different dates. I want to be able to select certain times out of the data and…
spergy
  • 49
  • 2
  • 8
1
vote
1 answer

Unable to download financial data with getFin() in R - HTTP status is '403 Forbidden'

I am trying to download financial data of companies. I have used getFin() quite a lot without encountering any problem. Right now, I am unable to download any data and when I use e.g. this code (and basically any other valid symbol instead of…
Pat Amat
  • 23
  • 7
1
vote
1 answer

R xts to.period for custom daily aggregation periods

I was wondering if its possible to aggregate custom periods. I tried to use to.period(x,"day",3,OHLC=FALSE) to aggregate but it didn't work as it just returned the lastest period. For example let x be a 2 day xts object with OHLC data. …
user1234440
  • 22,521
  • 18
  • 61
  • 103
1
vote
0 answers

What are FIX-Protocol 4.4 CURRENCY DERIVATIVES ( futures / options ) TAGS?

I have to implement Currency derivatives for Institutional model. We have a trading application. I would like to know are there any specific FIX-Protocol tags which are received or are to be sent from FIDESSA/BLOOMBERG terminals for Currency…
1
vote
0 answers

PHP: PPMT in 365 days

i am using PHP financial class http://www.phpclasses.org/package/892-PHP-Financial-functions-with-the-Excel-function-names-.html the PPMT function is calculating in 360 days but i need in 365 days. the function in the class looks like this: function…
M0ng0lZ
  • 11
  • 1
1
vote
1 answer

Financial Analysis in R - hoping to add Market Cap, P/FCF, EV/EBITDA, and Shareholder Yield to dataset

I'm admittedly a beginner in R and financial analysis as a whole. To better myself I've been working on a side project to automate a "Trending Value" screener. Essentially you pull 6 financial metrics - P/E, P/B, P/FCF, P/S, EV/EBITDA, and…
1
vote
1 answer

is reading large datasets (200gb) into dictionaries possible due to RAM constraint?

I am having a question on how Python function. I have a very large dataset (200 GB) and I am going to use python to iterate through lines, store data in a dictionary and then perform some calculation. Finally, I will write the computed data to a CSV…
duckman
  • 687
  • 1
  • 15
  • 30
1
vote
1 answer

purchasing in killos and selling in length? how to measure cost algo?

I am stuck in a situation where I need to come up with an effective way to calculate cost of pipes which is bought in KG and is sold in length and record cost for profit calculation in accounts.. things to consider: Even if i weight the pipes in…
inN0Cent
  • 363
  • 2
  • 18