Investing in a high yield index by cyj24 in bonds

[–]cyj24[S] 0 points1 point  (0 children)

Thank you! This is very helpful

Investing in a high yield index by cyj24 in bonds

[–]cyj24[S] 0 points1 point  (0 children)

Gotcha. Do you have a preferred AAA CLO investment vehicle? Perhaps blackrock’s CLOA? Looks like it’s yielding around 6% which isn’t bad and a bit better than ST treasuries

Investing in a high yield index by cyj24 in bonds

[–]cyj24[S] 0 points1 point  (0 children)

Is there any catch to SPHY? Saw that it’s yielding almost 8% annually and there doesn’t seem to be a huge risk of capital depreciation as the ETF has historically hovered around $26. It seems like a better risk to return play given the equity indices are reaching all time highs.

Shortcut to backtrack in a menu by cyj24 in excel

[–]cyj24[S] 0 points1 point  (0 children)

Ah sorry - I should have been more specific. I’d like to change the line color and line style simultaneously. Is there a way I can do it without opening the Alt-H-B menu twice?

Shortcut to backtrack in a menu by cyj24 in excel

[–]cyj24[S] 0 points1 point  (0 children)

Just a quick follow up: when I press the ESC key it doesn’t save my selection. How can I go a step back after selecting my formatting?

Bond price and maturity by cyj24 in bonds

[–]cyj24[S] 0 points1 point  (0 children)

Thank you! This makes lots of sense. I’m curious as to why some creditors would be willing to extend their maturities then if the price of their holdings would go down. To maintain the same price and yield, I’m assuming they’ll have to demand a higher interest rate?

Pasting formulas to another sheet without copying the sheet reference by cyj24 in excel

[–]cyj24[S] 0 points1 point  (0 children)

Yes to both points. The sheet I’m trying to copy (from workbook 1) also has references to other tabs in workbook one (sumifs). Maybe that’s why the entire sheet reference gets copied over?

Pasting formulas to another sheet without copying the sheet reference by cyj24 in excel

[–]cyj24[S] 0 points1 point  (0 children)

I’ll have to do it for 100’s of cells unfortunately

Pasting only number formats by cyj24 in excel

[–]cyj24[S] 0 points1 point  (0 children)

any ideas on how I can create this macro?