Premium Bond Winner ?

Bravepants

£0 on £30k for me this month. Making a rolling 12 month interest rate of : 3.24%.

Draw Month    Winnings    Holding

Jun-24    £250    £25,000
Jul-24    £0    £25,000
Aug-24    £50    £26,000
Sep-24    £100    £26,000
Oct-24    £0    £26,000
Nov-24    £25    £30,000
Dec-24    £350    £30,000
Jan-25    £50    £30,000
Feb-25    £175    £30,000
Mar-25    £0    £30,000

Apr-25    £0    £30,000

May-25    £200    £30,000

Jun-25   £0  £30000

A bit rubbish...three out of the last four months I've had zilch!

Might be time at last to scratch my Investment Trust dividend income itch!

kipsterno1

@Bravepants - Late to the party with your Excel issue which is now sorted but would the vlookup function have also speeded the process up? 

RetiredTaz

Nothing for me, third month in a row again on £21k. Even I’m beginning to think about cashing in now 🙁

Magnolia

£75 on FH for me.  Giving a calendar year total of £900

Congratulations @Swipe - I'm still waiting for my big win!

fly-catchers

£25 on FH.

Bravepants

kipsterno1 said:

@Bravepants - Late to the party with your Excel issue which is now sorted but would the vlookup function have also speeded the process up? 

I don't think Vlookup allows search for whether a cell value lies within a range of values defined by a pair of other cells' values, which is what is required. 

Also I realised you can just use SUM, no need for SUMPRODUCT...This is the function I use:

SUM((A$1:A$5<=C1)*(B$1:B$5>=C1))

So for example, I have five tranches of bonds, each tranche has a pair of bond numbers describing the range of numbers in the tranche. You can see these in your bond record in your NSI account. So I created a 5 by 2 table somewhere on my sheet. In this example its the columns A1:A5 and B1:B5. 

So,

Spreadsheet column A1:A5 contains the five lowest numbered bonds in each of the five tranches.

Spreadsheet column B1:B5 contains the five highest numbered bonds in each of the five tranches.

Cell C1 contains the bond number in a row of the winners list. 

A$1:A$5<=C1  produces a five element column of TRUE or  FALSE whether the C1 value is greater than or equal to the lowest numbered bond numbers in each of your tranches.

B$1:B$5>=C1  produces a five element column of TRUE or  FALSE whether the C1 value is less than or equal to the highest numbered bond numbers in each of your tranches.

Note that Excel handles both numeric and alphabetical "numbers", in other words it knows that Z > A for example! 

Multiplying the two columns together, produces another column of element by element products and then these are summed. Summing produces a 1 in the cell if the bond number appears anywhere in the range of the tranches that you own. 

So I inport the data file and create a column next to the data of elements containing the above function. I then COUNT the number of 1s appearing in the column to assess my level of disappointment!  

Hope this helps someone! LOL 

MACKEM99

I think I understand.😁

onomatopoeia99

Prizes since I bought up to a full holding:

Dec 24 - 1x £25

Jan 25 - 2x £50

Feb 25 - 1x £500

Mar 25 - 1x £50

Apr 25 - 2x£50, 1x £25

May 25 - 1x £100

Jun 25 - nil

seven month total £850

Alex.T

June 2025 No Wins, £10k holding. 

YTD £300 winnings.

anna42hmr

RetiredTaz said:

Nothing for me, third month in a row again on £21k. Even I’m beginning to think about cashing in now 🙁

don't blame you. I cashed mine in a few weeks back (10K) after a run of no wins for 5 months in a row. I was planning on cashing them in next June any way as using the money to pay off the mortgage at the end of my current fix, so decided to jump out early and stick it in a decent fixed rate savings account for the year, so will mean I will get the  guaranteed amount of interest rather than pot luck.