I'm working on importing data from our application into Oracle Financials GL. It seems simple with the GL_INTERFACE table, and many resources online, but I don't seem to understand it. A powerpoint presentation An import API I'm looking for a simple way to post a transaction of $X on a specific date, between 2 or more accounts. I'm ...
Hi, I need advice on how could I modify the parameters (high, low, close, open) of a data item in a OHLCSeries. Thanks. ...
Hello, For proper financial FX option pricing I require the exact number of business days between two dates. These dates can be up to 10 years in the future, for 2 different countries. I therefore need to know, in advance the holidays for both of those countries between the two dates. I plan to restrict myself to G20 countries for now. ...
We currently use excel automation to calculate time series statistics and store the results in our SQL Server 2008 database for easy display/sorting/etc. later. I'm currently redesigning the home screen of our app to present the most important information (as identified by the team using the app) in dashboard form. I'd like the display...
We are using C# .NET. We're looking for a method to display live streaming 1-min financial stock charts. Need: - Candlesticks - Zoom/pan - The chart scrolling in real time as it receives streaming data Woud like: - A method to print metadata on the chart (buy/sell points, etc) We don't mind paying for it, so any recommendation goes! ...
I was asked by my boss to create a module for calculating reverse compound. The question is: if I want to achieve $1.000.000,00 in 24 months with interest rate 18%/year (or 1.5%/month). how much money do I have to save every month? I searched on the internet, but found nothing except people referring to the Excel formula. Do you know ...
Hello, I am currently successfully downloading live Bloomberg market prices, as well as historical series, using the service's COM API and win32com. Does anyone have any experience doing the same for Reuters live and historical data into Python? I know that live feeds are available for both services in Excel, so Reuters must also have...
I'm pretty sure no one has ever written an application to analyze financial data (sarcasm). Regardless, I'm considering writing one for fun and need a way to access (1) large amounts of historical data and (2) real-time fluctuations in stock prices etc... (my finance jargon is weak). Is there an API (free or pay) that I can hook into t...
Over the last couple of weeks i have come across lots of articles about high frequency trading. They all talk about how important computers and software is to this but since they are all written from a financial point of view there is no detail about what does software do? Can anyone explain from a programmers point of view what is high...
I don't have a strong mathematical background, but I would love to work on some computational finance problems. I got "An Introduction to Computational Finance Without Agonizing Pain " by Peter Forsyth, but it still was pretty hard for me to follow what he was saying. What are the required maths prerequisites for this course? I want to...
I'm creating a "one-period" financial model in Excel - that is, a model where the formulas are consistent in each column, so you can copy/paste/extend them as desired. I'm breaking out the model's assumptions into a separate sheet. For instance, I have a cell named monthly_sales; that's how many new customers I add each month. The formu...
Could someone recommend resources (websites, books, mailing lists, forums, anything) about programming in R with use of financial data? Anyone? :) ...
Hello, We have a problem with rounding of floating point numbers for some financial calculations. Basically, we want to round monetary amounts like 1000000000.555 to 2 decimals. However, the float representation of this number is 1000000000.5549999 and as a result we will round down to 1000000000.55 rather than the correct 1000000000.5...
Hi All, I wanted to know how does Java/C# scale up compared to C++ with reference to financial industry projects ? Thanks. ...
Does anyone know a way to get the currency exchange rates for paypal? We have custom shopping cart and use Paypal (Website Payments Standard) to handle payments. Our 'home' currency is Euro, but we would like to present our customers the option to pay in different currencies (USD, CAD, AUD and GBP). PayPal offers the option to: a) ...
I'm interested in getting into developing trading systems, black box, HFT, etc. My primary experience is with C# and .Net (7 years). I've also done some sockets programming. I have some experience in finance working on analysis applications (2 years). My goal is to move into developing automated trading systems for a hedge fund, bank...
Can I use this google finance graph for my website ? http://1.bp.blogspot.com/%5FZaGO7GjCqAI/SKLQYz3h-cI/AAAAAAAAJ-Q/CMScCQuWW1M/s640/plot-feeds-in-google-finance.png ...
Hi, I'm trying to retrieve data for a Open-high-low-close (OHLC) chart directly from the database, it's the kind of chart you see of stocks. Is this possible, and if, how? I have a table like this (simplified): Date | Price | PriceType A record is created for each day, I will report per month / year, not per day as used for stocks. ...
Is it possible to read the realtime updated quotes in this website through actionscript3, without having to reload the page all the time, which would be network-heavy. In other words, is it possible to stream the quote-data directly into actionscript3 or eventually PHP from javascript? If not does anyone have any suggestion to how to g...
Hi, in this web http://www.fonerbooks.com/interest.htm, it has example to calculate mortgage. for example: the loan = 100.000 interest 5%/year payment : 12.000/month we got this table (on the web, 3rd table) Year Principal Interest Payment One 100,000 5,000 12,000 Two 93,000 4,650 12,000 ...