|
|
Post by longjohn on Mar 5, 2015 11:07:42 GMT
Thanks for trying, John. I'm still getting HTTP 500 Internal Server Error in response to "View Repayment Schedule" on my PC using Internet Explorer 11. Just tried Chrome browser on my tablet, and another mobile device, and they both just gave a blank white page. Odd. Maybe phone FC if it persists. 'View Repayment Schedule' gives a blank page for me as well. But I just switched accounts to a much smaller value account, with about 5% of the number of loan units in it, and it loads no problem. Can only think it's down to the size/number of loans/units. In a similar way the larger account struggles to download some monthly statements, and I can only get it to work for certain months in the wee hours of a Sat/Sun when there is no-one else about competing for server time. Take the number of loans you have and multiply by 60. This will give you the potential maximum number of rows of data. In reality it'll be less than this as you'll have many loans part repaid and not all loans will be for five years but it gives a ballpark figure. If Faulty Computers have limited their download row size to Excel limits (1048576 or 65536) or even less then that may be where the problem lies. John
|
|
|
|
Post by GSV3MIaC on Mar 5, 2015 17:01:15 GMT
Secondary market part listing: - FC confirmed to me that the default sort order is by loan part ID/number. I assume that this applies within another sort (like by buyer rate) too. So basically if you buy 10 parts as a block, you will probably sell them as a block too (assuming they are all marked up the same). Autobuy/bid =purchases= them at random, so this doesn't apply to parts listed at par, just parts sold at a discount or premium. Doesn't sound like the best idea they ever had, but I guess 'random' was harder to implement. I had a look at the listing order when you select an individual Loan Id to buy from. Every part on the SM has a unique number incremented each time a new part is listed. If you look at parts with the same buyer rate and price, then the SM Numbers are not sequential. For example, there is a large loan I looked at with 62 parts at 2.5% markup. It looks like parts were listed in 3 or 4 batches which are now mixed together. You can not see the part numbers, but this analysis appears to support the idea that buyers parts are not displayed in blocks, but are mixed together. Yes, I believe there are three numbers really - a loan number, a part number, and a SM listing number (which IIRC changes each time you list a part - even the same part). What FC were telling me is that the second one is the default sort order (but since, as you say, we can't see that one until after we buy the part it isn't easy to check). I guess someone who bough several parts of one loan at the same price/rate could look at the transaction report and see what order the part numbers came up in (I believe the second 'loan part' number is the ones that pops up in the transaction report). Then again they may have told me wrong, but it is surprising the number of times a block of parts sell together, whereas the same parts on my partner's account don't (or vice versa).
|
|
|
|
Post by mostlywrong on Mar 5, 2015 21:31:52 GMT
The Repayment Schedule problem is one that has been running for some time. Send an email to FC and one of the team will send you the latest schedule in Excel format. The symptom is a blank page when you click on the button. As far as I can tell, the problem is caused by size (ooh, Matron...) and a solution is promised!
The Excel problem caught me out a while ago. I have used Excel 97 on various machines and OS since, well, 1997. But, as has been pointed out, it has a limit of slightly more than 65,000 rows (which I had forgotten), and my clever manipulation of the FC data proved too much and it crashed.
I am now using Excel 2010 with the ribbon interface (which I hate). My VB macros copied across OK but I am not a VB expert so there was nothing complex therein.
I keep looking at Access and wondering whether I have the time and inclination to normalise and optimise all the data fields, write the queries, and then import 30 months worth of data. Perhaps we should start a thread about data handling...?
MW
|
|
sl75
Posts: 2,092 
Likes: 1,245
|
Post by sl75 on Mar 6, 2015 1:01:10 GMT
I had a look at the listing order when you select an individual Loan Id to buy from. Every part on the SM has a unique number incremented each time a new part is listed. If you look at parts with the same buyer rate and price, then the SM Numbers are not sequential. For example, there is a large loan I looked at with 62 parts at 2.5% markup. It looks like parts were listed in 3 or 4 batches which are now mixed together. You can not see the part numbers, but this analysis appears to support the idea that buyers parts are not displayed in blocks, but are mixed together. Yes, I believe there are three numbers really - a loan number, a part number, and a SM listing number (which IIRC changes each time you list a part - even the same part). What FC were telling me is that the second one is the default sort order (but since, as you say, we can't see that one until after we buy the part it isn't easy to check). I guess someone who bough several parts of one loan at the same price/rate could look at the transaction report and see what order the part numbers came up in (I believe the second 'loan part' number is the ones that pops up in the transaction report). Then again they may have told me wrong, but it is surprising the number of times a block of parts sell together, whereas the same parts on my partner's account don't (or vice versa). As well as the sort order, there's also the question of whereabouts in a list of identical loan parts someone will click the "buy" button... for myself, I'll often click about half way down whatever's on the screen at the time (which might be after expanding the list to 50 entries in order to check if there are any other loan part sizes available), or at several different arbitrary locations if I'm buying multiple parts.
|
|
|
|
Post by GSV3MIaC on Mar 6, 2015 15:57:33 GMT
SL75 .. if they are selling well and/or look like a good deal I'll usually click #2 or #3, so I don't get the 'this has already been bought' (well, not as often), but most (if not all) folks start at the top and work down through identical parts, at least that's what it looks like looking at my 'sold parts' list.
|
|
fasty
Member of DD Central
Posts: 1,038
Likes: 388
|
Post by fasty on Mar 6, 2015 16:01:48 GMT
Looks like another loan request just been pulled.. I recently bid on a request for a commercial mortgage at 10% fixed. Looks like it's simply vanished from the face of the earth and my money been spat back into my account without explanation
|
|
|
|
Post by GSV3MIaC on Mar 6, 2015 16:05:25 GMT
The Repayment Schedule problem is one that has been running for some time. Send an email to FC and one of the team will send you the latest schedule in Excel format. The symptom is a blank page when you click on the button. As far as I can tell, the problem is caused by size (ooh, Matron...) and a solution is promised! The Excel problem caught me out a while ago. I have used Excel 97 on various machines and OS since, well, 1997. But, as has been pointed out, it has a limit of slightly more than 65,000 rows (which I had forgotten), and my clever manipulation of the FC data proved too much and it crashed. I am now using Excel 2010 with the ribbon interface (which I hate). My VB macros copied across OK but I am not a VB expert so there was nothing complex therein. I keep looking at Access and wondering whether I have the time and inclination to normalise and optimise all the data fields, write the queries, and then import 30 months worth of data. Perhaps we should start a thread about data handling...? MW I cordially hated the damn ribbon too at first (not least because it broke all my 'conditionally add a command' VBA code), however I can work it OK now, and the 'customise quick access toolbar' feature which allows me to add direct links to my VBA procedures, and even say 'for this workbook only' is actually much more user friendly... plus you could (once upon a time) get excel 2010 in a 'use on several machines at home pack' for an almost reasonable price. I do hate the way they have screwed up graphing over the years, such that things which used to be easy (labelling all the points, producing wide screen graphs, etc. etc) are now either hard or impossible. And VBA is still moderately flaky as a programming language .. fast to develop with, reasonably fast to run, but flaky (sometimes you can catch it completely failing to do what the code says .. unless you reset, and completely reload the worksheet, or cut/paste the offending section so it gets recompiled correctly).
|
|
|
|
Post by goldservice on Mar 6, 2015 16:27:36 GMT
In the spirit of 'That Microsoft, Again' I remember that in the 1990s in MS WinWord you could do things like select a rectangle of text with sides within the line ends. Then one day they had to stop using unpublished API hooks (anti-trust case?) and a host of special features disappeared.
|
|
|
|
Post by GSV3MIaC on Mar 21, 2015 8:19:01 GMT
After a couple of pretty much error free weeks, the website seems sick again this am, with 500 or 503 errors when I try to view any loan pages (or just nothing at all). The rest (,SM etc) seems OK. I guess improvements are underway .. Or maybe tiz delayed reaction to the eclipse?
|
|
fasty
Member of DD Central
Posts: 1,038
Likes: 388
|
Post by fasty on Mar 21, 2015 11:03:25 GMT
I'm having extreme difficulty placing bids this morning (Saturday). I think it may be a divine sign that the bids really aren't worth placing right now.
|
|
|
|
Post by davee39 on Mar 21, 2015 11:24:10 GMT
I'm having extreme difficulty placing bids this morning (Saturday). I think it may be a divine sign that the bids really aren't worth placing right now. Do you really need a divine sign? While I was building up my holding I would regularly have 5 to 10% of the funds as bids in progress. Currently it is zero and withdrawals are routinely being made twice weekly.
|
|
maxmarengo
Member of DD Central
Posts: 96
Likes: 28
|
Post by maxmarengo on Mar 28, 2015 15:31:41 GMT
Back from holiday and I have discovered that the format of the statement records for lender fees has changed since 20 March. Time to open up the VB again.
Or is it just an error that will be fixed? Looking at it the record starts "Lender Fee for Loan ID N/A;..". So probably just a bug.
|
|
baldpate
Member of DD Central
Posts: 549
Likes: 407
|
Post by baldpate on Mar 28, 2015 17:27:26 GMT
"Or is it just an error that will be fixed?" Is there such a thing in FC-world? Most bugs seem to turn into permanent feaures. I've already recoded on the assumption that, even if it's a bug, it won't get fixed anytime soon.
|
|
|
|
Post by GSV3MIaC on Mar 28, 2015 17:37:34 GMT
Back from holiday and I have discovered that the format of the statement records for lender fees has changed since 20 March. Time to open up the VB again. Or is it just an error that will be fixed? Looking at it the record starts "Lender Fee for Loan ID N/A;..". So probably just a bug. I pointed it out on the thread about account errors ... I would guess that FC are planning to add the loan number to some, if not all, transaction statement lines, which is something I have been bitching about for years. Clearly the database isn't giving them the answer(s) yet, but at least there is now a place for it to go. Meantime I still have / use my own cross reference table(s) based on parts I bought / sold and guesswork. Go and recode .. I did (but I wasn't optimistic enough to recode to extract the loan ID from that field .. one day maybe .. and whether they'll update history, who knows!)
|
|
maxmarengo
Member of DD Central
Posts: 96
Likes: 28
|
Post by maxmarengo on Mar 28, 2015 17:56:53 GMT
Baldpate and GSV - my thoughts exactly - have already recoded.
Have also filled in the survey from the Money mag - it is important that FC get the credit they deserve!
|
|
