Hot answers tagged

15 votes

Paying off an installment

Using Annuity: pmt /.Solve[TimeValue[Annuity[pmt, 52, 1], .02, 0] == 5000, pmt] 155.545 ...
kale's user avatar
  • 10.9k
13 votes

Creating a Stock Dataset

Dataset has been designed for hierarchical data and will fit your problem well. You should start by mapping out the hierarchy and then building a function that ...
Edmund's user avatar
  • 42k
12 votes
Accepted

Use Alpha Vantage as an alternative to Yahoo FinancialData, and how to use financial indicators on these data

Here is something I quickly came up with after a cursory reading of the docs: ...
J. M.'s eventual burnout's user avatar
10 votes
Accepted

How to download and combine S&P 500 stock prices?

From the question formulation I am not sure what is the desired end result: a time series or a table. It seems to be the latter but I give solutions for both. I am using a sample of the stocks for ...
Anton Antonov's user avatar
10 votes
Accepted

How can I plot my financial indicator below a trading chart (produced by TradingChart) with the same x-axis?

It appears you can define your own indicators to be used with TradingChart (this doesn't seem to be documented though): ...
Lukas Lang's user avatar
  • 33.6k
9 votes
Accepted

Reinvention of TradingChart

So here's some stuff to get you started: We'll start with a more general candle image function: ...
b3m2a1's user avatar
  • 46.8k
8 votes

Paying off an installment

The general formula can be derived as follows. ...
bbgodfrey's user avatar
  • 61.3k
8 votes

Creating a Stock Dataset

Here are a few things to get you started. My code is for demonstration purposes only and is neither optimized for computational speed nor memory, but it's concise and produces pretty potent results. ...
Gregory Klopper's user avatar
8 votes

Use Alpha Vantage as an alternative to Yahoo FinancialData, and how to use financial indicators on these data

So this is something that can really be answered just by reading the docs, but maybe it'll be generally useful, so I'll put it here. First I got an API key from those people, then extended your ...
b3m2a1's user avatar
  • 46.8k
8 votes

Is FinancialData about to be deprecated?

The situation with FinancialData has been discussed in some detail on https://community.wolfram.com/groups/-/m/t/1847045. In a nutshell: data availability has indeed been affected as a result of ...
C. Alan Joyce's user avatar
7 votes
Accepted

FinancialData[], what does "members" include?

What is included in FinancialData["NYSE", "Members"] appear to be stocks, indices, and exchange traded funds (ETFs). One can see this by finding the intersection of ...
Virgil's user avatar
  • 3,427
7 votes
Accepted

Looking up Stock Symbols in Mathematica

Update WL used to provide data for ^N225, it no longer does. The following indexes are currently available FinancialData["Indices"] Names of those ...
Rohit Namjoshi's user avatar
6 votes

Intra day data with TradingChart

Update: In version 11.3.0 and version 12.2.0 the the following replacement rule works: ...
kglr's user avatar
  • 392k
6 votes
Accepted

Wrong Cashflow of Annuity with initial payment

WRI replied, finally: We believe that the issue has been resolved in the current 13.2.1 release of Mathematica. I don't have the newest version installed so I cannot verify. But I think we can take ...
asterix314's user avatar
  • 1,325
6 votes
Accepted

American option priced incorrectly by `FinancialDerivative`?

Using the setting "Binomial" for the option Method gives 1.2625: ...
kglr's user avatar
  • 392k
6 votes

Use Alpha Vantage as an alternative to Yahoo FinancialData, and how to use financial indicators on these data

Here is an example to build on top of Twelve Data OHLCV candles. The advantage is that they offer real-time data throughout the trading session, that AV fails to deliver for some important stocks. <...
Wang Xiu Ying's user avatar
6 votes

Monte Carlo simulation of a financial market

You use memoization in your code. In some cases that may be quite useful. Personally, I use it rarely, because it mixes data and operations on that data in a rather unfavorable way: After a single run ...
Henrik Schumacher's user avatar
6 votes
Accepted

Very slow rendering of Quantity

I logged a call and it's a known issue. Will be fixed in a upcoming next release of Mathematica. Pinky Swear. Update: presumably version 12.1 Just tested this again and with Mathematica 12.1 it's ...
Lou's user avatar
  • 3,822
6 votes
Accepted

two tier compound interest problem

Assuming the payments change when the rate changes. Then using an example of a 100k mortgage on 4% (nominal) for two years, then 6% for three more years. (Formula derivations shown below.) Note, if ...
Chris Degnen's user avatar
  • 30.8k
5 votes
Accepted

Paying off an installment

Just to show how to fix the origional loop: ...
george2079's user avatar
  • 38.9k
5 votes
Accepted

Plotting a DateListPlot and a CandleStickChart together

The underlying issue is that CandlestickChart is not using date values on its x-axis. With First@y we can see that the x-axis ...
Edmund's user avatar
  • 42k
5 votes
Accepted

Look up a non-US stock price

While it does not exist as curated data, fortunately for you, Prague stock exchange published the data out for free in a very similar fashion to Yahoo Finance historical data feed. So you need to <...
Gregory Klopper's user avatar
5 votes

Historical Exchange Rates via FinancialData

You may derive data from WolframAlfa request (10Y period). Copy the Pod Plot (de facto Graphics) and get ...
garej's user avatar
  • 4,845
5 votes

Paying off an installment

Using the example for an ordinary annuity from here:- Calculating The Present And Future Value Of Annuities The example demonstrates how a present value principal of 4329.48 is paid down by five ...
Chris Degnen's user avatar
  • 30.8k
5 votes
Accepted

Theoretical value of a financial option

I don't get the exact same answer as the calculator I found here or here or here. Sadly, I can't get any of them to agree with each other when we ask for "American" pricing, so there seems to be some ...
Jason B.'s user avatar
  • 67.9k
5 votes
Accepted

MATLAB to Mathematica CorrelationMatrix implementation

That was already a very good start. I take your function and modify it only slightly. I anticipate from the Matlab code that not the indices but the maturities ...
Henrik Schumacher's user avatar
5 votes

How to change all stock prices to USD?

You are calling UnitConvert[Quantity[n, "KoreanWon"], "USDollars"] for every value of n. ...
Jason B.'s user avatar
  • 67.9k
5 votes

How can I plot my financial indicator below a trading chart (produced by TradingChart) with the same x-axis?

Start: ...
Steffen Jaeschke's user avatar
5 votes

Is there a CryptocurrencyData alternative to FinancialData?

There are multiple crypto-currencies data sources, but a small proportion of them give a convenient way of extracting crypto-currencies data automatically. I found the easiest to work with to be https:...
Anton Antonov's user avatar
5 votes
Accepted

Log of time series evaluated

The QuantityMagnitude command does the work. ...
user64494's user avatar
  • 25.7k

Only top scored, non community-wiki answers of a minimum length are eligible