lobster
Member of DD Central
Posts: 636
Likes: 467
|
Post by lobster on Mar 30, 2017 14:38:49 GMT
Very prompt work 0risk and it's much appreciated. I'm sure I speak for many here in thanking you for your contribution to this board.
|
|
|
Post by portlandbill on Mar 31, 2017 8:11:05 GMT
I've been trying to find a way of listing all my loans and showing both the interest rate being paid, and the remaining term. Even downloading the excel spreadsheet from the Lendy site doesn't help as it doesn't show the interest %.
Is this what this thread is supposed to help with? It's all far to complicated for my feeble brain to understand.
|
|
|
Post by dan1 on Mar 31, 2017 8:16:02 GMT
I've been trying to find a way of listing all my loans and showing both the interest rate being paid, and the remaining term. Even downloading the excel spreadsheet from the Lendy site doesn't help as it doesn't show the interest %. Is this what this thread is supposed to help with? It's all far to complicated for my feeble brain to understand. The easiest way is to simply look at "Live Loans" on the Lendy site. If you need a record simply copy the text and paste into excel or whatever.
|
|
|
Post by portlandbill on Mar 31, 2017 8:51:15 GMT
I've been trying to find a way of listing all my loans and showing both the interest rate being paid, and the remaining term. Even downloading the excel spreadsheet from the Lendy site doesn't help as it doesn't show the interest %. Is this what this thread is supposed to help with? It's all far to complicated for my feeble brain to understand. The easiest way is to simply look at "Live Loans" on the Lendy site. If you need a record simply copy the text and paste into excel or whatever. Yes, but that shows all live loans, not just mine.
|
|
|
Post by dan1 on Mar 31, 2017 8:53:22 GMT
The easiest way is to simply look at "Live Loans" on the Lendy site. If you need a record simply copy the text and paste into excel or whatever. Yes, but that shows all live loans, not just mine. Then yes, the browser extension will allow you to see rate and duration on your "Live Loanparts" page.
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Mar 31, 2017 8:59:23 GMT
The easiest way is to simply look at "Live Loans" on the Lendy site. If you need a record simply copy the text and paste into excel or whatever. Yes, but that shows all live loans, not just mine. If you want to have it offline then sort what you scraped by 'invested', delete all the £0 rows then you can play with what's left (your loans) how you like.
|
|
|
Post by portlandbill on Mar 31, 2017 9:05:33 GMT
Yes, but that shows all live loans, not just mine. If you want to have it offline then sort what you scraped by 'invested', delete all the £0 rows then you can play with what's left (your loans) how you like. does "scraped" mean cutting from the Lendy site and pasting into excel? If so, when I do that I get all the data in one cell.
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Mar 31, 2017 9:30:06 GMT
If you want to have it offline then sort what you scraped by 'invested', delete all the £0 rows then you can play with what's left (your loans) how you like. does "scraped" mean cutting from the Lendy site and pasting into excel? If so, when I do that I get all the data in one cell. Yes- not sure what you did but ..... >click and hold just to the left of the first picture (PBL166) then drag across and down so all the data you want highlights blue >Release mouse button >CTRL+C >to spreadsheet >select cell A2 (leave top row to add the headers manually after if you want them) >Paste Special (select unicode text in the box to avoid getting links in your data) The data spreads across lines so to tidy up ..... >Adjust column A width so you can see it better > select data in cells B3:I169 (ie all) >Cut (CTRL+x) >Select Cell B2 >Paste (CTRL+v) Then just need to lose the blank rows >Sort by column H - Largest to smallest and all the blanks and zeros will be at the bottom of the list >Delete those to be left with your loans Quick and easy once you know what to do !
|
|
|
Post by portlandbill on Mar 31, 2017 9:44:38 GMT
does "scraped" mean cutting from the Lendy site and pasting into excel? If so, when I do that I get all the data in one cell. Yes- not sure what you did but ..... >click and hold just to the left of the first picture (PBL166) then drag across and down so all the data you want highlights blue >Release mouse button >CTRL+C >to spreadsheet >select cell A2 (leave top row to add the headers manually after if you want them) >Paste Special (select unicode text in the box to avoid getting links in your data) The data spreads across lines so to tidy up ..... >Adjust column A width so you can see it better > select data in cells B3:I169 (ie all) >Cut (CTRL+x) >Select Cell B2 >Paste (CTRL+v) Then just need to lose the blank rows >Sort by column H - Largest to smallest and all the blanks and zeros will be at the bottom of the list >Delete those to be left with your loans Quick and easy once you know what to do ! That works! Thanks, Treeman, I was selecting from the right. Now when i select from the left, it's fine. Cheers
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Mar 31, 2017 9:53:15 GMT
Yes- not sure what you did but ..... <SNIP> Quick and easy once you know what to do ! That works! Thanks, Treeman, I was selecting from the right. Now when i select from the left, it's fine. Cheers No worries - same basic idea (with a bit of tweaking for specific oddities) works on most sites for any non-downloadable tables. Now all you need is a bullet-proof investment strategy
|
|
0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on Apr 2, 2017 15:47:28 GMT
New version of FILTER LOANS (v1.12):
- Added a check box option to show All Loans on sale.
Source code: openuserjs.org/scripts/0risk/FilterLoans/source To update you click on "Install" and then "Update".
You can also copy and paste the script. For security reasons, I don't recomend using TamperMonkey built-in auto-update.
See first messages on this thread for more instructions.
Note: TamperMonkey is also available for Chrome, Firefox, Edge, Safari, Opera Next. Site: tampermonkey.net
|
|
|
Post by freedommmm on May 10, 2017 9:04:19 GMT
I am using Chrome and installed TamperMonkey. However, when going for the script installation, when I click "Install" button, nothing happens for a while, and then I had the "connection refused" page. After refreshing a couple of times, I got the prompts to install and to confirm. But then I got a yellow messages at the top "Apps, extensions, and user scripts cannot be added from this website" and a blue OK button.
Yet when I logged into Lendy, the script appears to be actually installed and running!
|
|
|
Post by hobbitcz on May 23, 2017 22:13:31 GMT
|
|
0risk
Member of DD Central
Posts: 217
Likes: 202
|
Post by 0risk on May 23, 2017 22:34:47 GMT
I'm not sure if I understood you well. Auto fill is only done on a popup window, when a desired loan is found. (Desired loans are defined by the variable buyLoans) If you click yourself on a loan it won't be filled automatically. Also, we call it popup, but in fact it's a new tab really. You can put something like this to test: var buyLoans = { 'PBL155': 10, }; If you go to the available loans, it should open a new tab with this loan and fill in 10 automatically.
|
|
ncp
Posts: 19
Likes: 20
|
Post by ncp on May 29, 2017 15:49:35 GMT
Hi Orisk, many thanks for these terrific scripts. Work for me using firefox extension.
Not being a JS programmer is it possible, within the script, to create a variable equal to the "available funds" figure shown in the accounts overview heading; and then be able to assign that variable, rather than a physical amount, when listing loans for 'auto-popup'. This would than populate the popup with the maximum I could invest in a loan part without having to alter figures within the script, or altering the populated figure, each time the available funds are reduced.
Just being lazy I suppose, but the speed at which some of these loan parts get filled, every little edge can help.
|
|