Questions related to quantifying risk and the allocation of assets and liabilities over time under conditions varying uncertainty--including questions on the use of the built-in financial functions of Mathematica.

learn more… | top users | synonyms

6
votes
1answer
528 views

How to download and combine S&P 500 stock prices

I want to download historical S&P 500 stock prices and combined them into one big file, having only one column of date referencing all stocks. Here is what I have do so far. ...
6
votes
3answers
231 views

Creating a custom distribution with specified skew and kurtosis

Let's say I want to create a simulated sample of returns for a given investing/trading strategy. I know that my strategy is profitable on 64% of trades, that the ratio of mean win / mean loss is 0.72, ...
3
votes
1answer
79 views

Theoretical value of a financial option

I am using the following function to get option pricing but it does not give me the right answer ($10.50). Where is my problem: ...
3
votes
3answers
325 views

Median household income for each county in Maryland

I found that Wolfram|Alpha knows the median household income for every county in the US. I wanted to get a list of all counties in Maryland, and the median income in each county. The only way I could ...
14
votes
3answers
906 views

Mathematica usage (success stories) for financial back-ends

I've been working for about 5 years in Java, developing financial back-offices (web-services, business logic, report generation etc.). I think Mathematica is very suitable for such calculations and ...
6
votes
4answers
589 views

Paying off an installment

How do I determine the weekly installment I have to pay, if my loan is, let's say, loan=5000, with interest rate of 2% every ...
0
votes
1answer
76 views

getting stock price from financial data

I would like to print only the stock price from below input , i have been trying since a couple of hours with no luck..this is what I did ...
2
votes
1answer
76 views

Can not Solve FinancialDerivative for volatility

Although Solve can solve FinancialBond for an input parameter (e.g. par) given the price of a bond: ...
3
votes
1answer
130 views

I want to compute the derivative of Black and Scholes option

Good evening to everybody, my question is about computing the derivative of a Black and Scholes option and to draw it. My code is ...
18
votes
6answers
1k views

Historical Exchange Rates via FinancialData

FinancialData["name"] and FinancialData["name", start] return respectively; the last known price, and the daily closing values ...
7
votes
0answers
91 views

Mathematica and Wolfram Alpha - Long data series [duplicate]

Let's say I want a long series of data with the Mexican peso / US dollar exchange rate. The old code I used back in the day was FinancialData["USD/MXN", All] ...
15
votes
1answer
191 views

FinancialData[], what does “members” include?

I am doing some manipulation of historical stock prices on the NYSE. I want to go through each stock. To find the number of entities on NYSE, one can use: ...
3
votes
2answers
103 views

Plotting a DateListPlot and a CandleStickChart together

I'm trying to plot a DateListPlot and a CandleStickChart together. Initially I was trying to add a FinancialIndicator by spelunking TradingChart, but it's quite complex, I think I could manage to do ...
3
votes
1answer
113 views

Why is TimeSeriesForecast linear?

When I use FinancialData with TimeSeriesForecast, the resulting graph is always linear and thus not very accurate. ...
4
votes
2answers
159 views

Initializing FinancialData indices … never finishes

Bug introduced in 10.3.0 and fixed in 10.3.1 Retrieving data using FinancialData became more unreliable in the last couple of months, but simply retrying was ...
2
votes
0answers
38 views

How to find euro zone equivalent of treasury data in U.S. using FinancialData?

For example I use FinancialData["^TYX", "Price", {{2004}, {2014}, "Week"}]; to get data for U.S. treasury data, can I do the same for eurozone yield curve? I know I ...
2
votes
2answers
46 views

Partition a list into TradingChartformat

I want to make a stock chart by using TradingChart with my own data. But, the imported data is in the format ...
4
votes
0answers
90 views

Wrong Cashflow of Annuity with initial payment

If we use TimeValue to look at the PV of an Annuity with initial payment: The initial payment ...
4
votes
1answer
139 views

Finding Distribution based on quantile data

I am trying to determine an approximate distribution based on quantile data. I have the following information regarding Profit/Loss from an investing strategy backtest, and I want to use the data to ...
7
votes
1answer
190 views

Methods Available for Derivative Pricing in Mathematica?

I am using Mathematica to price options (built in functions, no need to reinvent the wheel, right?). In the documentation, the Binomial method is used as an example of specifying a non-standard ...
1
vote
1answer
92 views

Defining a Function

I've been reading about functions in Mathematica and playing with this for hours, but I'm clearly missing something. The following code correctly calculates "fail", the number of failed scenarios. I ...
1
vote
1answer
241 views

Can Mathematica 10 do elliott wave calculations?

Seems like there are quite a few fibonacci / Golden Ratio type functions but nothing in the doc's or Financial implementations ...
1
vote
0answers
50 views

Autocorrelation in Tail Events

I have a single time series of financial data (stock index returns) and would like to study the autocorrelation among (log-)returns that are classified as "extreme", for example via exceedance of a ...
1
vote
0answers
46 views

Problem with `NMinimize` [closed]

I wrote a code inspired by Rod's answer to this question. It is supposed to find the minimum variance portfolio of stocks and allows for arbitrary constraints on the weights of each stock: ...
-1
votes
0answers
55 views

Relative Volatility Index in Mathematica [closed]

How does Mathematica calculate Relative Volatility Index?
2
votes
2answers
148 views

In FinancialData what is the difference between FractionalChange and Change?

In FinancialData there are two similarly named properties one can request for a given stock symbol: Change and ...
3
votes
1answer
316 views

Plot A Function Of A Stochastic Process

I am trying to do something very simple in Mathematica 9. I want to play around with option pricing and for that I thought it best to use the new stochastic process functionality. So, first of all I ...
3
votes
1answer
141 views

Intra day data with TradingChart

I am trying to use TradingChart to display some intra day data (60 s. resolution). Is there a way to modify the time displayed when moving the mouse over the data. The default setting (see top left of ...
5
votes
2answers
258 views

Time Zone Conversion

I use Mathematica to administer my share depots. The depots contain shares of many different time zones. I update the depot values several times a day. My problem is that Sidney, Australia, (it might ...
3
votes
0answers
78 views

Possible bug in fetching price index data?

I seem only able to fetch price index data for the U.S. For example, the following fails (Mathematica 10.2): ...
1
vote
1answer
77 views

Comparing stock indices using TradingChart [closed]

Below I show a TradingChart specific to the SP500 index for a one month period. How do I produce a similar plot where three other indices (ASX200, Shanghai Comp, ...
5
votes
0answers
164 views

How can I program my own financial indicator to be plotted in a TradingChart?

FinancialIndicator["ind", par1, par2, ...] represents a financial indicator "ind" with parameters $par1$, $par2$, etc. All available financial indicators can be ...
6
votes
1answer
172 views

How to retrieve the remaining cashflows from a FinancialBond object

I would like to get the cash flows and dates for the remaining coupons and principal repayment for a FinancialBond object. These must be calculated internally by ...
7
votes
1answer
159 views

Determining FinancialData for Countries

How do I determine the FinancialData for Australia. For instance the one for USA follows as: FinancialData["NYSE", "Members"] ...
4
votes
2answers
365 views

Should we invest in Apple?

Ticker[comp_String] := Interpreter["Company"][comp] /. Entity[_, x_] :> x ticks = Ticker /@ {"Apple", "Google"} {"NASDAQ:AAPL", "NASDAQ:GOOGL"} ...
0
votes
2answers
275 views

“Part specification is longer than depth” warning in Position function [duplicate]

I'm working on a project which analyzes financial data. I download the price and dividend information for the SPY ETF which tracks the S&P 500: ...
4
votes
2answers
157 views

Use of Ito's lemma in ItosLemma.m (or any other method in Mathematica)

This is a follow-up question on this question: Use of Ito's lemma in ItoProcess My problem is to find some method how to use Ito's lemma in Mathematica. As an example: How can I apply Ito's ...
1
vote
1answer
201 views

How can I connect the Interactive Brokers TWS API to Mathematica using RLink for automated trading?

I do know there is documentation for the IB TWS Java API. However, instead of Java, I would like to establish a connection between Mathematica and the IBrokers API module using RLink as a 'proxy' to ...
1
vote
1answer
105 views

InteractiveTradingChart and ChartElementFunction

I want plot a similar candlestick chart as on the picture below with blue down-candles and white up-candles with blue edges. With TrendStyle -> {White, Blue} I don't see shadows on up-candles ...
3
votes
1answer
272 views

Use of Ito's lemma in ItoProcess

In the documentation for the ItoProcess it says: Converting an ItoProcess to standard form automatically makes use of ...
1
vote
2answers
166 views

Simulation of LogNormal process for an asset pricing

I'm new to Mathematica programming, so forgive my rather unsophisticated question. I need to simulate 5000 "walks" of a process value (of a stock) that starts from its current value, at ...
0
votes
0answers
66 views

FinancialData, comparing returns accounting for different holidays

At the moment I am trying out the FinancialData feature of mathematica. I am a bit struck with the problem of dropping returns for dates of a list of different stocks not being equal for all stocks ...
5
votes
0answers
194 views

Forecasting problem with Geometric Brownian Motion in Wolfram Mathematica [closed]

I'm a full time undergraduate student from Peru, and I'm trying to use the Geometric Brownian Motion example used in the help section from Wolfram Mathematica in order to forecast future stock ...
0
votes
1answer
184 views

Financial data source change

So I am using the command FinancialData["name"] to get the live price for any given stock. The openings are very important in my studies that I am conducting and it ...
2
votes
2answers
92 views

Is there any way to pull interest rates, or an interest rate curve, with FinancialData[]?

Let's say I want to know the 5 year swap rate and the 10 year swap rate right now, is there a way to get this with FinancialData[]?
1
vote
1answer
74 views

How can I plot bollinger bands on financial time series? [closed]

I can't find any options for this in CandlestickChart[], but it's a pretty basic measure, is it not supported?
0
votes
2answers
119 views

Martingale pricing_Simulation random walk stock price

I need to make an example of a walk of a stock price.I have this data: and i need to resolve this equation: where "W" is a Wiener process [0,Δt]. I need to make a path of 157 steps(date of ...
1
vote
0answers
149 views

Create trading chart from Bloomberg historical data [closed]

I am using Mathematica 9 with the Finance Platform, and have pulled historical data for the Bloomberg Commodity Total Return Index using the following code. ...
1
vote
1answer
103 views

Traffic growth forecast: showing the change of linear regression

The following picture shows a changement in the trend of data. (The data used are available here). Is there any tool that can show this change of trend? Until now I managed to show even more ...