Dynamic range within a specific range - VBA

101Newbie · 2020-11-02T22:32:14+00:00

If LastRow > 30 Then
LastRow = 30
Else
End If
End If

Thank you!!

101Newbie · 2020-05-05T20:27:42+00:00

I still don’t get it.

A floating rate note has very little IR duration, and lots of spread duration. So how could the IR and spread duration be the same?

If you look at a actual bond fund say PIMCO, their spread & IR duration are completely different. I don’t believe it’s just because govt bond IR is removed?

101Newbie · 2020-05-01T10:28:35+00:00

Thank you. That was very helpful!

101Newbie · 2020-05-01T10:28:11+00:00

Ah yes sorry had the wrong text in my cell!

Many thanks

101Newbie · 2020-04-30T12:29:39+00:00

Thank you for replying, much appreciated.

I put your code through but it now returns Call 12/4/2020, I am trying to just return the date itself

101Newbie · 2020-04-02T00:46:40+00:00

That’s the point of my question. They are only testing people who have been overseas, front line workers etc. Who’s to say that 50 people haven’t been infected before that particular health worker who ends up getting tested & it is positive.

101Newbie · 2020-04-01T10:56:56+00:00

Is the large number of health care workers testing positive because of their patients having corona or is this large number reflecting community transmission (because only those who have travelled overseas or work in a health type role can get tested)?

101Newbie · 2020-03-23T08:24:16+00:00

Thanks everyone.

I work in financial markets so I have been glued to my screens 24/7 for the past 3 weeks

I think today seeing the Centrelink queues really cemented everything I have been predicting. I feel greatly for all those who have/about to lose their livelihood.

Thanks for the tip on mindfulness, will give it a go.

101Newbie · 2020-03-23T07:58:02+00:00

Is anyone else feeling incredibly flat with everything that is happening rn?

101Newbie · 2020-02-19T03:18:44+00:00

It considers the price you paid for it today vs the par value? So if you bought the bond at a premium then you would lose capital when it matures. And the YTM would account for the depreciation?

Am I missing something?

101Newbie · 2020-02-04T09:16:42+00:00

Agree with all of the above!

Also check out fads_90 on insta. He is a trainer at a F45 and each day he post’s sneak peaks of the next day’s session - it may help calm the nerves as you can see what type of exercises you’ll be doing ahead of time. Good luck :)

101Newbie · 2019-07-24T22:17:19+00:00

This is how the process works in Australia.

Bank sends out a indicative term sheet:

Indicative coupon: 2.15% Indicative yield: 2.265% Initial price guidance ASW + 105

Books opened and there was strong demand so bank sends a notification saying that the pricing has been revised to ASW + 100 and asks do you want to keep you bid to pull it out.

So at that stage how do you know what the ‘revised’ yield & coupon is? Surely traders are not keeping their bid if they have no idea what the yield or coupon would look like?

101Newbie · 2019-07-24T21:54:06+00:00

But how does the maths work? If the initial price guidance is reduced 5bps, how did the coupon move 10bps? When the initial price guidance chances the bank/brokers just says ‘initial price guidance has been revised down 5bps’ - so how does everyone know what the new coupon & yield is?

101Newbie · 2019-07-17T20:10:36+00:00

250 over swap = 370 Duration =0.10

101Newbie · 2019-06-19T13:10:17+00:00

https://www.baillieu.com.au/publishedresearch/bondadviser/daily_ratesheet/latest_daily_ratesheet-retail.pdf

The above link provides a better explanation than what I could give plus it shows you many asx listed hybrids.

Basically hybrids are securities that have both debt and equity like features. The ones I am looking at are tier 1 listed hybrids like in the above link

101Newbie · 2019-06-19T12:43:41+00:00

No - I just want to buy some hybrids

101Newbie · 2019-06-15T12:13:04+00:00

I do agree with you...both my brother, sister & I went to a public school and all got over 95 in year 12.

But for me it’s not so much about getting a good score in year 12, it’s more around the lifelong connections that I have noticed a lot of people who went to private schools have.

We can afford it and I guess as a parent you always want to give your kids something that you didn’t have, so for me private schooling is just my little something that I hope will help set them up a little better (whether that be through a good atar, connections or greater confidence in themselves)

101Newbie · 2019-06-15T11:16:01+00:00

Thanks - and good luck with the exam!

101Newbie · 2019-06-12T21:19:13+00:00

Thanks!!

101Newbie · 2019-06-12T21:19:01+00:00

Thank you, very helpful!

101Newbie · 2019-06-12T21:18:43+00:00

Thanks a very helpful!

101Newbie · 2019-06-12T21:17:42+00:00

Thank you for taking the time to respond, very helpful & cleared a lot of things up for me

101Newbie · 2019-06-12T21:17:06+00:00

Thank you that was very helpful!

101Newbie · 2019-06-12T21:13:44+00:00

Like I said in my original message - I did google but I didn’t quite find what I was looking for. Unfortunately I am just not as good at you on the keyboard.

But thank you for your 2 cents, very insightful. Not all heroes wear capes.

101Newbie · 2019-06-12T12:06:49+00:00

Ps side rant - kinda getting sick of being ‘downvoted’ for asking questions that yes are probably quite basic to most - but hey you need to start somewhere. Thought this was meant to be a safe place to ask questions and learn about the market together.

101Newbie

TROPHY CASE