P/E Ratio Comparison

A custom indicator created by TrendSpider on TrendSpider. You can import this custom indicator into your TrendSpider account. Don't have TrendSpider? Create an account first, then import the custom indicator.

This indicator compares the P/E ratios of MSFT, AAPL, GOOGL, NVDA, and TSLA.

Source code

This indicator had been implemented by TrendSpider in JavaScript on TrendSpider. Check out the developer documentation to learn more about JS on TrendSpider.

// This script had been cloned from "P/E Ratio comparison" at 26 Jan 2024, 15:52
describe_indicator('P/E Ratio Comparison', 'lower');

const symbolsToCompareTo = ['MSFT', 'AAPL', 'GOOGL', 'NVDA', 'TSLA'];

const epsMathType = input('P/E Type', 'Trailing', ['Qtr', 'Trailing']);
const scale = input('Scale', 'Linear', ['Linear', 'Log']);


async function computePELine(ticker, options, isReference) {	
	const earnings = await request.earnings(ticker);
	const otherAssetPrice = await request.history(ticker, constants.resolution, { land_onto_current_candles: true });

	if (!Array.isArray(earnings)) {
		return;
	}

	const pastEarnings = earnings.filter(record => !record.isFuture);

	let resultingLine = null;

	if (epsMathType == 'Qtr') {	
		const epsLanded = land_points_onto_series(
			pastEarnings.map(record => record.timestamp),
			pastEarnings.map(record => record.eps),
			time,
			'ge'
		);

		const epsInterpolated = interpolate_sparse_series(epsLanded, 'constant');
		resultingLine = for_every(otherAssetPrice.close, epsInterpolated, (c, eps) => c / eps); 
	}
	else if (epsMathType == 'Trailing') {	
		resultingLine = otherAssetPrice.close.map((c, index) => {
			const last4QtrEPS = pastEarnings.
				slice(0, index).
				filter(Boolean).
				slice(-4).
				reduce((result, report) => result + report.eps, 0);
				
			return c / last4QtrEPS;
		});
	}
	else {
		throw Error('unknown pe type requested');
	}

	if (scale == 'Log') {
		resultingLine = resultingLine.map(Math.log);
	}
	
	return { line: resultingLine, options, isReference };
}

const ratios = await Promise.all([
	computePELine(constants.ticker, { name: 'PE, Base', thickness: 2 }, false),
	...symbolsToCompareTo.map(symbol => computePELine(symbol, { name: `PE, ${symbol}` }, true))
]);


let maxLine = series_of(-1e6);
let minLine = series_of(1e6);

for (const ratioLine of ratios) {
	paint(ratioLine.line, ratioLine.options);

	if (ratioLine.isReference) {
		maxLine = max_of(maxLine, ratioLine.line);
		minLine = min_of(minLine, ratioLine.line);
	}
}

fill(
	paint(maxLine, { hidden: true }),
	paint(minLine, { hidden: true }),
	'blue',
	0.1
);