20 replies to this topic

[Goldfinger]

Hi

Has anyone asked Zopa to introduce "up" and "down" clicky buttons on the lender screen so you can change the rates without having to mess around with cumbersome drop downs?

Have zopa considered introducing a Zopa tracker facility so your offer rate tracks the bid/mid/offer (plus or minus and increment)then you don't need to keep coming back to update rates.

[PoohBah]

Goldfinger, on 10 January 2012 - 10:24, said:

Has anyone asked Zopa to introduce "up" and "down" clicky buttons on the lender screen so you can change the rates without having to mess around with cumbersome drop downs?

I should image that up and down buttons would also be pretty fiddly, unless you are just wanting to move one or two decimal places.  I suppose there is no reason why not, but I doubt that it would get a very high priority.

Quote

Have zopa considered introducing a Zopa tracker facility so your offer rate tracks the bid/mid/offer (plus or minus and increment)then you don't need to keep coming back to update rates.

I think this has been discussed before in some depth (no doubt somebody will do the search!).  Just image the effect if everyone decided to try tracking the rates.  It would completely defeat the object of setting the rates that suit you, and there would be the risk that you could end up lending much too cheaply.

[MikeS1531]

Goldfinger, on 10 January 2012 - 10:24, said:

Has anyone asked Zopa to introduce "up" and "down" clicky buttons on the lender screen so you can change the rates without having to mess around with cumbersome drop downs?

You can -- sort of -- do this now.  If you click on the drop-down arrow once to drop down the list and then again to make the list disappear, you can then use the up/down arrow keys on your keyboard to accomplish what you want to do.

[Goldfinger]

PoohBah, on 10 January 2012 - 12:26, said:

I should image that up and down buttons would also be pretty fiddly, unless you are just wanting to move one or two decimal places.  I suppose there is no reason why not, but I doubt that it would get a very high priority.

Just speaking from personal experience I just keep one offer and edit it when the rates change to get my money lent out at the best rate available at the time. To achieve this I usually select rates that are 0.1% higher then the "In the Zone" rate but it is difficult to find this switch point as you have to increase or decrease each rate by 0.1% at a time. It's 2 clicks on the way up and 3 clicks on the way down verses 1 cick either way with up/down clicky buttons (or a slider).

It's just a suggestion for improvement but it might just be me being panickety about number of clicks what with my RSI.....

Edited by Goldfinger, 10 January 2012 - 17:39.

[Goldfinger]

PoohBah, on 10 January 2012 - 12:26, said:

I doubt that it would get a very high priority.

It's only a minor change that could be done in 2 mins

[Fairdeal1023]

MikeS1531, on 10 January 2012 - 17:28, said:

You can -- sort of -- do this now.  If you click on the drop-down arrow once to drop down the list and then again to make the list disappear, you can then use the up/down arrow keys on your keyboard to accomplish what you want to do.

Nice trick mike i tried it and it works

Thanks

Edited by elljay, 10 January 2012 - 18:59.
Fix the quoting

[adilowes]

Fairdeal1023, on 10 January 2012 - 18:12, said:

Nice trick mike i tried it and it works

Thanks

Also once you have set one rate then you can tab across to get down to the next rate. r at least you could. Not changed my rates for a while as very little fluctuation for some time or at least not to affect me anyway.

[andyg]

I'd like to have an up and down button that changed all your rates at once.

[figures18]

andyg, on 11 January 2012 - 21:35, said:

I'd like to have an up and down button that changed all your rates at once.

I can't see any logic in that at all.  Would you like to explain why please?

[andyg]

I have a very simple lending strategy... I don't mind which markets I lend to, so once I've adjusted my rates for bad debt estimates and tax, I can then move all of them up and down by the same amount to optimise returns and lending speed. I think... Or have I got something badly wrong?

Net effect of this approach seems to be that I'm lending exclusively in the A* 60 month market at the moment.

Andy G

[figures18]

andyg, on 11 January 2012 - 22:34, said:

I have a very simple lending strategy...  I think... Or have I got something badly wrong?

Net effect of this approach seems to be that I'm lending exclusively in the A* 60 month market at the moment.

Nothing wrong with a simple strategy/lending in all the markets but as you've seen each market dances to its own tune by which I mean where 'in the zone' is and what return you can achieve.  This is because of variables such as demand/disbursals/lender rates-money on offer and even how much money is tied up in processing for each individual market.

Simply put if you're only getting A*60's then the return you're looking for across all the markets is too high.  Either stick to that decision or adjust down in each market separately till you're in the zone but still happy with the rate, and pull up in A*60 when feasible.

[Gorgeous George]

andyg, on 11 January 2012 - 22:34, said:

I have a very simple lending strategy... I don't mind which markets I lend to, so once I've adjusted my rates for bad debt estimates and tax, I can then move all of them up and down by the same amount to optimise returns and lending speed. I think... Or have I got something badly wrong?

Net effect of this approach seems to be that I'm lending exclusively in the A* 60 month market at the moment.

Andy G

Are you accounting for the tax treatment of bad debt?

I lend to A*/A only and my bad debt is a lot less than that which Zopa's estimates would expect. (Excluding listings, Zopa estimate is 122.57 and I have 37.28 in default status).

GG

[andyg]

Yep I am accounting for the tax treatment of bad debt too, which I guess is why I am not seeing any loans in the riskier markets. If I now tweak my rates down in just, say, the C market then I would expect a lower return, after bad debt etc. from my C loans than the others, which is not what I am after. So I go for the highest rate that gets my money lent out.

Andy G

[MikeS1531]

Gorgeous George, on 12 January 2012 - 06:41, said:

I lend to A*/A only and my bad debt is a lot less than that which Zopa's estimates would expect. (Excluding listings, Zopa estimate is 122.57 and I have 37.28 in default status).

I'd like to make a similar comparison for my account.  How did you work out how much bad debt the Zopa estimates would have resulted in?  I can work out what my actual bad debt rate is in percentage terms by comparing it to my Zopa fee, but how do I relate that to the estimates since I have loans in a variety of market/terms and each of those has a different estimated bad debt rate?

[CKemahli]

I personally would also like a way of shifting all rates up in increments at once.

I take the monthly inflation rate figure, apply my own addition too it and move my rates accordingly. Not the most scientific method, but it means once a month I have to go through all 10 boxes and move each one by the same amount.

Couldn't be too hard to include, up arrow click, all rates move 0.1% up and vice versa for down. Minor tweaks could still be carried out using the drop down boxes.


A way of being able to save your offers would benefit me as well, say I wanted 6% above bad debt, I could save that as 6%....then if my offer was fiddled during usual use, I could just click the {apply 6%} rule and all the rates would revert to that offer....just a thought. Having multiple offers does little for me as I keep all funds in one.

[Gorgeous George]

MikeS1531, on 12 January 2012 - 11:22, said:

I'd like to make a similar comparison...

Hi Mike

For A*36...

Firstly, I use Geoff's wonderful spreadsheet.

Secondly, on a new worksheet...

Use the formula '=SUMIF(WSSelect!R:R,'Bad Debt'!'S36',WSSelect!AE:AE)'. This will calculate the fees paid in A*36 and as I pay 1.0% fees while Zopa estimate 0.5% bad debt then Zopa's estimated bad debt in £ is 0.5/1.0 times the fees that I have paid. In my case, £71.44 paid in fees for A*36 loans so the bad debt estimate is £35.72 for this market. Repeat for other markets. (I actually put the market code, S36, in a cell to the left of the SUMIF formula and refer to it rather than typing it in directly).

I use a formula to calculate bad debt assuming all lates will turn bad with no further payments being made. Possibly a pessimistic approach. For the post earlier post in this thread I simply added up the value of the S36 loans where the status is 'default'. I could do this automatically but the pessimistic approach described earlier is good enough for me.

Regards

George

[MikeS1531]

Gorgeous George, on 12 January 2012 - 19:04, said:

Use the formula '=SUMIF(WSSelect!R:R,'Bad Debt'!'S36',WSSelect!AE:AE)'.

Thanks for the suggestion.  However...

I added a new sheet/page to the Geoffj model and put the formula --

=SUMIF(WSSelect!R:R,'Bad Debt'!'S36',WSSelect!AE:AE)

-- in Cell A1... and Excel tells me there's an error.  Excel, being the exceedingly user-friendly program that it is, gives no useful clue as to what the error is or how I might fix it.  

Anybody have any suggestions?

[Lloyd]

MikeS1531, on 13 January 2012 - 04:38, said:

Thanks for the suggestion.  However...

I added a new sheet/page to the Geoffj model and put the formula --

=SUMIF(WSSelect!R:R,'Bad Debt'!'S36',WSSelect!AE:AE)

-- in Cell A1... and Excel tells me there's an error.  Excel, being the exceedingly user-friendly program that it is, gives no useful clue as to what the error is or how I might fix it.  

Anybody have any suggestions?

I'm not sure about the apostrophes around Bad Debt and S36, and as an extension, do you have a tab called "Bad Debt"?

[MikeS1531]

Lloyd, on 13 January 2012 - 08:00, said:

I'm not sure about the apostrophes around Bad Debt and S36, and as an extension, do you have a tab called "Bad Debt"?

Thanks to your help, I've sorted it.  

1) I didn't have a sheet called "Bad Debt".  That must have been the name GG assigned to the sheet he added to the workbook.  I've now renamed the sheet I added.

2) I think the quote marks are needed around "Bad Debt" because of the space between the words.  I called my sheet "BadDebt" so I don't have the same issue.

3) I think the quotes around "S36" are needed because the comparison is with a cell containing text.

In the end I did what GG did, which is to put the Market/Term I'm checking into a cell on the sheet so the formula can refer to that cell instead of "S36".  By doing that, I can make a list of the complete set of Markets/Terms and just copy the formula to produce the appropriate sums.

So my working formula looks like...

=SUMIF(WSSelect!R:R,BadDebt!A6,WSSelect!AE:AE)

... where cell A6 is the location of the Market/Term I'm looking for.

[Gorgeous George]

MikeS1531, on 13 January 2012 - 04:38, said:

Thanks for the suggestion.  However...

Lloyd, on 13 January 2012 - 08:00, said:

I'm not sure about the apostrophes around Bad Debt and S36, and as an extension, do you have a tab called "Bad Debt"?

MikeS1531, on 13 January 2012 - 12:10, said:

Thanks to your help, I've sorted it.  

1) I didn't have a sheet called "Bad Debt".  That must have been the name GG assigned to the sheet he added to the workbook.  I've now renamed the sheet I added.

2) I think the quote marks are needed around "Bad Debt" because of the space between the words.  I called my sheet "BadDebt" so I don't have the same issue.

3) I think the quotes around "S36" are needed because the comparison is with a cell containing text.

In the end I did what GG did, which is to put the Market/Term I'm checking into a cell on the sheet so the formula can refer to that cell instead of "S36".  By doing that, I can make a list of the complete set of Markets/Terms and just copy the formula to produce the appropriate sums.

So my working formula looks like...

=SUMIF(WSSelect!R:R,BadDebt!A6,WSSelect!AE:AE)

... where cell A6 is the location of the Market/Term I'm looking for.

Well done guys and apologies for my disappointingly useless post. Hopefully, now that it is working, you get the info that you want Mike.



George