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

What is the proper formula for calculating the future value of compound interest with end of period deposits

I'm trying to recreate this app. However, for cases where the frequency of deposits do not match the compounding periods, my fuction's output doesn't match the linked app's output for the total value of investment. Here's my function... def…
Acubal
  • 173
  • 1
  • 2
  • 8
2
votes
1 answer

Delete Sheets With No Color, Remove Comments from All Sheets, Break Links to All Sources

I am currently working on my first ever VBA macro to run the functions described in the title. I currently have the following code. It appears to be working as intended, but I would love a second set of eyes to tell me if I have any unintended…
K Pres Excel
  • 23
  • 2
2
votes
3 answers

How to aggregate OHLC bars with mongodb?

I have 1 min OHLC bars on some market data that I imported into Mongo DB. Each document looks like this: { "_id" : ObjectId("5ac3163f31a0632c7642ca1c"), "Date" : "08/06/2007", "Time" : "15:01", "Open" : 1310, "High" : 1310.25, …
jersey bean
  • 3,321
  • 4
  • 28
  • 43
2
votes
0 answers

Pandas more efficient looping financial data

I am working on a pandas Financial series dataframe and iterating through the rows to test stops and targets. With a large dataset this takes way too long. The main problem that I have is the that the data['Signal']fires only when the boundary…
user3757265
  • 427
  • 1
  • 4
  • 11
2
votes
1 answer

Error downloading quantmod data

I am currently following a financial video and I am at minute 8:02 of the following video. I believe that I am going wrong in regard to downloading the data as the author of the video has done. I have pasted the code below which you should be able…
user113156
  • 6,761
  • 5
  • 35
  • 81
2
votes
1 answer

what is a good schema design for a loan origination system?

I am designing a loan origination system which would allow it's users to create loans, draw repayment schedule of the loan depending on the loan product parameters. I should also be able to add penalty, fees etc. Rescheduling loan should be…
piyush
  • 601
  • 3
  • 23
2
votes
1 answer

R - Shiny can not find "container"

I am trying to create a basic financial shiny app that takes a company's ticker symbol as it's input and utilizes various functions in the quantmod package to return certain information (income statement, cash flow, etc.). I'm running into and error…
m_squared
  • 105
  • 9
2
votes
0 answers

Incorrect card number when swiping with Magtek Card Reader

I'm am currently working on a POS web app, where we use the credit card swipe functionality. I'm planning to use the card reader: MagTek 21073062 Dynamag Magnesafe Triple Track Magnetic Stripe Swipe Reader with 6' USB Interface Cable, 5V, Black I…
rajkris
  • 1,775
  • 1
  • 9
  • 16
2
votes
1 answer

How to get financial, 1st and last date of each month of whole year

Financial Year I want to get financial year by using Jquery, Check the example as i have 12 fields and every field is having a month name and in the same row it also shows the 1st and last date of month, some how i reached at the point but unable to…
Salman Khan Sohoo
  • 97
  • 1
  • 1
  • 13
2
votes
1 answer

Lag values and differences in pandas dataframe with missing quarterly data

Though Pandas has time series functionality, I am still struggling with dataframes that have incomplete time series data. See the pictures below, the lower picture has complete data, the upper has gaps. Both pics show correct values. In red are the…
Martien Lubberink
  • 2,614
  • 1
  • 19
  • 31
2
votes
1 answer

apple App store / wp7 marketplace W-8BEN form - is ITIN required if my country has double taxation avoidance treaty wit US?

Hi I am about to submit my first paid app for apple's app store and soon wp7 marketplace. The paperwork required to avoid 30% taxation is pretty confusing for me. I am living in the EU. 1) I haven't seen W-8BEN form at itunes connect - do I need to…
adrin
  • 3,738
  • 8
  • 40
  • 60
2
votes
1 answer

Calculating IV60, and IV90 on interactive brokers

I am trading options, but I need to calculate the historical implied volatility in the last year. I am using Interactive Broker's TWS. Unfortunately they only calculate V30 (the implied volatility of the stock using options that will expire in 30…
Luis Cruz
  • 1,488
  • 3
  • 22
  • 50
2
votes
1 answer

quantmod <- Having trouble writing a formula to extract single day returns without headers

I am attempting to write a formula that will return a stocks single day return, but I believe im having trouble with the data type of the periodReturn subset field periodReturn(ticker,period='daily',subset='20161010::20161010') works but dayReturn…
Frank Drin
  • 1,613
  • 2
  • 13
  • 18
2
votes
1 answer

Predicting multivariate time series with RNN

I have been experimenting with a R package called RNN. The following is the code site: https://github.com/bquast/rnn It has a very nice example for financial time series prediction. I have read the code and I understand it uses the sequence of the…
learning-man
  • 119
  • 2
  • 11
2
votes
1 answer

Automate several calculations in R through data frames

I have a series of vectors, each of them named as a stock, like FB for Facebook Inc. So I have over 70 series of vectors inside a data frames, for example, GEEK, IPAS, JCON etc. Over each pair of stocks, say for example, GEEK and JCON, I have to…
Alex Quintino Barbi
  • 55
  • 6
1 2 3
…
23 24