Jump to content


Help - things seem to have changed


  • Please log in to reply
3 replies to this topic

#1 BrianS

BrianS

    Zeus

  • Members lvl 1
  • PipPipPipPipPipPip
  • 837 posts
  • Gender:Male
  • Location:Hitchin

Posted 18 June 2012 - 00:21

Although I have logged in to, and read, the fora fairly regularly for the last couple of years, I have not looked at the available spreadsheets within the main website for quite a while.

One thing I notice is that lenders usernames appear to be  a sequence of stars, and it is difficult (hopefully not impossible) to find where my offer is in the spreadsheet.

Can someone please suggest the easiest way to find MY offer within the CSV download available from the main site.

I do know when the offer was made, and the markets it was made in as well as the amount available when the offer was made. I also know the rate it was offered at.

Having downloaded the CSV I have found difficulty in locating MY offer, and would like to know where I am going wrong as it should be a reasonably easy search.

I have MS Excel 2007 on Win7 Home 64bit, just in case that makes a difference.

#2 figures18

figures18

    Zeus

  • Members lvl 1
  • PipPipPipPipPipPip
  • 4,985 posts
  • Gender:Female
  • Location:Nutty Hollow

Posted 18 June 2012 - 00:33

Once you've downloaded the spreadsheet use Ctrl F, or the 'find' facility and input/search for your lender username.  If the rate you're offering at is in the queue at a point lower than or equal to a £20k match it'll find you, (in each separate market).  Once a market offer matches higher than £20k you effectively 'disappear'.

HTH

Edited by figures18, 18 June 2012 - 00:41.

I should give myself a daily smiley allowance - sometimes I use too many!!

#3 MikeS1531

MikeS1531

    Zeus

  • Members lvl 1
  • PipPipPipPipPipPip
  • 3,163 posts
  • Gender:Not Telling
  • Location:Herefordshire

Posted 18 June 2012 - 21:41

View Postfigures18, on 18 June 2012 - 00:33, said:

Once you've downloaded the spreadsheet use Ctrl F, or the 'find' facility and input/search for your lender username.  If the rate you're offering at is in the queue at a point lower than or equal to a £20k match it'll find you, (in each separate market).  Once a market offer matches higher than £20k you effectively 'disappear'.
It probably goes without saying, but offers also disappear from the spreadsheet if they run out of funds.

#4 figures18

figures18

    Zeus

  • Members lvl 1
  • PipPipPipPipPipPip
  • 4,985 posts
  • Gender:Female
  • Location:Nutty Hollow

Posted 18 June 2012 - 22:44

View PostMikeS1531, on 18 June 2012 - 21:41, said:

It probably goes without saying, but offers also disappear from the spreadsheet if they run out of funds.
Yes, but I forgot to say it so thanks for adding it to the answer.  Good to see you back  :D
I should give myself a daily smiley allowance - sometimes I use too many!!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users