' + escapeHtml(val) + '';
}).join('');
return '' + cells + '
';
})
.join('');
}
function setActiveTopTab(tab) {
activeTopTab = tab;
if (!els.topSellingTabs) return;
els.topSellingTabs.querySelectorAll('.bond-tab').forEach(function (btn) {
var active = btn.getAttribute('data-tab') === tab;
btn.classList.toggle('active', active);
btn.setAttribute('aria-selected', active ? 'true' : 'false');
});
renderTopSelling();
}
function setupOnShelfFilters() {
fillSelect(
els.filterBondType,
uniqueSorted(
onShelfRows.map(function (r) {
return String(getField(r, ONSHELF_KEYS.type) || getField(r, ONSHELF_KEYS.typeAlt) || '').trim();
})
),
t.all
);
fillSelect(
els.filterCurrency,
uniqueSorted(
onShelfRows.map(function (r) {
return String(getField(r, ONSHELF_KEYS.currency) || '').trim();
})
),
t.all
);
fillSelect(
els.filterRisk,
uniqueSorted(
onShelfRows.map(function (r) {
return formatRisk(getField(r, ONSHELF_KEYS.risk));
})
).filter(function (v) {
return v !== '—';
}),
t.all
);
}
function updateOnShelfSortButtons() {
if (!els.onshelfSortBtns) return;
els.onshelfSortBtns.querySelectorAll('.bond-sort-btn').forEach(function (btn) {
var key = btn.getAttribute('data-sort');
var active = key === onShelfSort;
btn.classList.toggle('active', active);
if (key === 'maturity') {
btn.textContent = t.maturity + ' ' + (active && onShelfSortDir === 'desc' ? '↓' : '↑');
} else if (key === 'coupon') {
btn.textContent = t.coupon + (active ? (onShelfSortDir === 'asc' ? ' ↑' : ' ↓') : '');
} else if (key === 'risk') {
btn.textContent = t.risk + (active ? (onShelfSortDir === 'asc' ? ' ↑' : ' ↓') : '');
}
});
}
function renderOnShelf() {
if (!els.onshelfBody) return;
var typeFilter = els.filterBondType ? els.filterBondType.value : '';
var currencyFilter = els.filterCurrency ? els.filterCurrency.value : '';
var riskFilter = els.filterRisk ? els.filterRisk.value : '';
var rows = onShelfRows.filter(function (row) {
var type = String(getField(row, ONSHELF_KEYS.type) || getField(row, ONSHELF_KEYS.typeAlt) || '').trim();
var currency = String(getField(row, ONSHELF_KEYS.currency) || '').trim();
var risk = formatRisk(getField(row, ONSHELF_KEYS.risk));
if (typeFilter && type !== typeFilter) return false;
if (currencyFilter && currency !== currencyFilter) return false;
if (riskFilter && risk !== riskFilter) return false;
return true;
});
rows = rows.slice().sort(function (a, b) {
var cmp = 0;
if (onShelfSort === 'coupon') {
cmp =
couponSortValue(getField(a, ONSHELF_KEYS.coupon) || getField(a, ONSHELF_KEYS.couponAlt)) -
couponSortValue(getField(b, ONSHELF_KEYS.coupon) || getField(b, ONSHELF_KEYS.couponAlt));
} else if (onShelfSort === 'risk') {
var ra = parseNumber(String(getField(a, ONSHELF_KEYS.risk)).replace(/[^\d.]/g, '')) || 0;
var rb = parseNumber(String(getField(b, ONSHELF_KEYS.risk)).replace(/[^\d.]/g, '')) || 0;
cmp = ra - rb;
} else {
var ya = parseNumber(getField(a, ONSHELF_KEYS.years));
var yb = parseNumber(getField(b, ONSHELF_KEYS.years));
cmp = (ya == null ? Infinity : ya) - (yb == null ? Infinity : yb);
}
return onShelfSortDir === 'asc' ? cmp : -cmp;
});
updateOnShelfSortButtons();
if (!rows.length) {
els.onshelfBody.innerHTML =
'| ' + escapeHtml(t.emptyFilter) + ' |
';
return;
}
els.onshelfBody.innerHTML = rows
.map(function (row) {
var isin = getField(row, ONSHELF_KEYS.isin);
var name = getField(row, ONSHELF_KEYS.name);
var currency = getField(row, ONSHELF_KEYS.currency);
var coupon = formatCoupon(getField(row, ONSHELF_KEYS.coupon) || getField(row, ONSHELF_KEYS.couponAlt));
var freq = formatFreq(getField(row, ONSHELF_KEYS.freq));
var years = formatYears(getField(row, ONSHELF_KEYS.years));
var risk = formatRisk(getField(row, ONSHELF_KEYS.risk));
return (
'' +
'| ' + escapeHtml(isin || '—') + ' | ' +
'' + escapeHtml(name || '—') + ' | ' +
'' + escapeHtml(currency || '—') + ' | ' +
'' + escapeHtml(coupon) + ' | ' +
'' + escapeHtml(freq) + ' | ' +
'' + escapeHtml(risk) + ' | ' +
'' + escapeHtml(years) + ' | ' +
'
'
);
})
.join('');
}
function renderScenario(key) {
var s = SCENARIOS[key];
if (!s || !els.scenarioPanel) return;
els.scenarioTabs.querySelectorAll('.bond-scenario-tab').forEach(function (btn) {
btn.classList.toggle('active', btn.getAttribute('data-scenario') === key);
});
var linesHtml = (s.lines || [])
.map(function (line) {
return (
'' +
escapeHtml(line.label) +
'' +
escapeHtml(line.value) +
'
'
);
})
.join('');
var totalHtml = '';
if (s.totalLabel && s.totalValue) {
totalHtml =
'' +
escapeHtml(s.totalLabel) +
'' +
escapeHtml(s.totalValue) +
'
';
}
els.scenarioPanel.innerHTML =
'' +
'
' + escapeHtml(s.title) + '
' +
'' +
'' + escapeHtml(s.desc) + '
' +
(linesHtml ? '' + linesHtml + '
' : '') +
totalHtml;
}
async function loadData() {
if (typeof XLSX === 'undefined') {
showError('Unable to load page resources. Please refresh.');
return;
}
if (window.location.protocol === 'file:') {
showError('Open via local server to load bond data.');
return;
}
try {
var res = await fetch(DATA_FILE, { cache: 'no-store' });
if (!res.ok) throw new Error('HTTP ' + res.status);
var buf = await res.arrayBuffer();
var workbook = XLSX.read(buf, { type: 'array', cellDates: true });
topSellingRows = sheetToJson(workbook, ['Top selling bond', 'Top selling bond ']);
onShelfRows = sheetToJson(workbook, ['On-shelf Bond List', 'On-shelf Bond List ', 'Bond List']);
if (!topSellingRows.length) throw new Error('No Top Selling data found');
setActiveTopTab(activeTopTab);
if (onShelfRows.length) {
setupOnShelfFilters();
renderOnShelf();
} else if (els.onshelfBody) {
els.onshelfBody.innerHTML =
'| No On-Shelf bond data found. |
';
}
} catch (err) {
showError(t.loadError);
console.error(err);
}
}
if (els.topSellingTabs) {
els.topSellingTabs.addEventListener('click', function (e) {
var btn = e.target.closest('.bond-tab');
if (btn) setActiveTopTab(btn.getAttribute('data-tab'));
});
}
if (els.scenarioTabs) {
els.scenarioTabs.addEventListener('click', function (e) {
var btn = e.target.closest('.bond-scenario-tab');
if (btn) renderScenario(btn.getAttribute('data-scenario'));
});
renderScenario('hold');
}
['filterBondType', 'filterCurrency', 'filterRisk'].forEach(function (id) {
if (els[id]) els[id].addEventListener('change', renderOnShelf);
});
if (els.onshelfSortBtns) {
els.onshelfSortBtns.addEventListener('click', function (e) {
var btn = e.target.closest('.bond-sort-btn');
if (!btn) return;
var key = btn.getAttribute('data-sort');
if (onShelfSort === key) {
onShelfSortDir = onShelfSortDir === 'asc' ? 'desc' : 'asc';
} else {
onShelfSort = key;
onShelfSortDir = key === 'coupon' ? 'desc' : 'asc';
}
renderOnShelf();
});
}
document.querySelectorAll('.bond-top').forEach(function (link) {
link.addEventListener('click', function (e) {
e.preventDefault();
window.scrollTo({ top: 0, behavior: 'smooth' });
});
});
document.querySelectorAll('.bond-anchor').forEach(function (link) {
link.addEventListener('click', function (e) {
var href = link.getAttribute('href') || '';
if (href.charAt(0) !== '#') return;
var target = document.getElementById(href.slice(1));
if (!target) return;
e.preventDefault();
var offset = 120;
var top = target.getBoundingClientRect().top + window.pageYOffset - offset;
window.scrollTo({ top: Math.max(0, top), behavior: 'smooth' });
if (history.replaceState) {
history.replaceState(null, '', href);
}
});
});
loadData();
})();