If I am not wrong, ISIN numbers last position is a verification digit. What is the mathematical function that determines its value in function of the first 11 digits?

What is the fastest library/algorithm for calculating simple moving average? I wrote my own, but it takes too long on 330 000 items decimal dataset. period / time(ms) 20 / 300; 60 / 1500; 120...

numpy has irr and npv function, but I need xirr and xnpv function. this link points out that xirr and xnpv will be coming soon. http://www.projectdirigible.com/documentation/spreadsheet-functions....

Is there an implementation for python pandas that cache the data on disk so I can avoid to reproduce it every time? In particular is there a caching method for get_yahoo_data for financial? A ver...

I am using the Ta-lib library in my C# project to calculate Exponential moving averages. I have to calculate EMA for 20 periods. I did my calculation on a spreadsheet (Excel) and I got the correct ...

I've been following 'python for data analysis'. On pg. 345, you get to this code to plot returns across a variety of stocks. However, the plotting function does not work for me. I get FigureCanvas...

I have a database with lets assume two columns (service_date & invoice_amount). I would like to create an SQL query that would retrieve and group the data for each financial year (July to June)...

I'm working on converting a mortgage calculator in PHP, but I don't necessarily need a PHP solution. I'm looking for the logic needed to replicate the Excel RATE function. I've found a solution whi...

I am using geom_boxplot to draw candlesticks using stock market data. The problem is that the individual boxplot's upper and lower edges as well as the upper whisker end point show up way higher on...

I know that Yahoo has a great API for accessing detailed financial metrics about a company documented at http://www.gummy-stuff.org/Yahoo-data.htm. Yahoo also provides historical pricing data...

I am curious about the existence of any "rounding" standards" when it comes to the calculation of financial data. My initial thoughts are to perform rounding only when the data is being presented t...

My problem is quite common in finance. Given an array w (1xN) of weights and a covariance matrix Q (NxN) of assets, one can calculate the covariance of the portfolio using the quadratic expression...

Now that the oligopole of market data providers successfully killed OpenQuant, does any alternative to proprietary and expensive subscriptions for realtime market data subsist? Ideally I wou...

I'm migrating my financial analysis application data from MongoDB to InfluxDB because the data and the analysis is growing exponentially. My current scenario is: 1) Get the tick every second from...

I have an issue that touches both accounting and database principles. I have a table called Payments that, among other columns has this structure: ------------------------------- id | amount | typ...

I have the following candles +----------------+-------+----------+---------+----------+ |date |curency|high_price|low_price|last_price| +----------------+-------+----------+---------+----------+ ...

Apple has for some time had a tool, AutoIngest.class for downloading iTunes Connect sales and trend reports. Is there is a similar tool (or modified use of it) to pull the financial reports ...

Im in need for good candlestick chart for my web app and chart at http://bitcoinwisdom.com/ is really what Im looking for. I like the way you can zoom and move with it. Is it possible to figure out...

The company I'm working for has a financial year that starts on 1st January if that is a Thursday, otherwise starts on the last Thursday of the previous year. I've written a function that does thi...

Was wondering, anyone know how to get data automatically from Edgar? (free or otherwise) I've looked into getting it from yahoo/google, but they consolidate information (like different revenue cat...

So, my app was a "hit", and I'm making US$1.2k a day... But I don't see "Payments and Financial Reports" updated for the month of February. If at all I get this payment, this would be my firs...

I'm writing a Bitcoin trader app that is fetching orderbooks from exchanges. A typical orderbook looks like this: https://www.bitstamp.net/api/order_book/ (it has two parts, "bids" and "asks", they...

Has anyone ever run across pain.008.002.02 format? It is an ISO standard used in Germany used for direct debit transactions. The problem I have is that although I had found documentation that talks...

When I calculate the Internal Rate of Return (irr) using the numpy method irr, I receive nan as return. In [45]: numpy.irr([-10, 2, 2, 2, 2]) Out[45]: nan Shouldn't the results be at least negat...

i am writing a financial WPF desktop application and i am looking for a component that would allow me to display (and print) OHLC, candlestick, and possibly other types of financial charts. I...