Title: Automatically downloading notes.csv file: anyone know how to
Post by: Kombinator on August 06, 2013, 11:00:00 PM
Post by: Kombinator on August 06, 2013, 11:00:00 PM
I am looking to have the file programmatically downloaded into Excel, does anyone have any experience doing it, and if so can you please share whether it can be done, as well as possibly ideas / specific code that enables this download.
Many thanks in advance.
Many thanks in advance.
Title: Automatically downloading notes.csv file: anyone know how to
Post by: viking on August 06, 2013, 11:00:00 PM
Post by: viking on August 06, 2013, 11:00:00 PM
You can use a free Macro add-on such as iMacros (for FF, IE & Chrome) and create a simple Macro to "automatically" download the file. The CSV file can then be opened in Excel.
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on August 07, 2013, 11:00:00 PM
Post by: TravelingPennies on August 07, 2013, 11:00:00 PM
Very interesting, can you say a bit more about this method please...?
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on August 07, 2013, 11:00:00 PM
Post by: TravelingPennies on August 07, 2013, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: loan_trader on March 10, 2014, 11:00:00 PM
Post by: loan_trader on March 10, 2014, 11:00:00 PM
My question is along the same lines as this thread.
I have figured out how to automatically download the file to excel so I can run my own queries on it.
However, my problem is that I don't know how to detect that a new set of notes has come out so I can download the most updated file. Normally I'll refresh the page until I see a new one is out then manually run my scripts...but I'd like to have this automatically download only when new notes are issued (it seems like they are at random times up to 2 or 3 minutes past the hours they are suppose to come out). Anyway to do this without the API?
also, is there a glossary for all the additional fields that are in the file?
thanks,
dan
Title: Automatically downloading notes.csv file: anyone know how to
Post by: Fred on March 10, 2014, 11:00:00 PM
Post by: Fred on March 10, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: Keltset on March 10, 2014, 11:00:00 PM
Post by: Keltset on March 10, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: RaymondG on March 12, 2014, 11:00:00 PM
Post by: RaymondG on March 12, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 17, 2014, 11:00:00 PM
Post by: TravelingPennies on March 17, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 18, 2014, 11:00:00 PM
Post by: TravelingPennies on March 18, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 18, 2014, 11:00:00 PM
Post by: TravelingPennies on March 18, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 19, 2014, 11:00:00 PM
Post by: TravelingPennies on March 19, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 19, 2014, 11:00:00 PM
Post by: TravelingPennies on March 19, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: AnilG on March 19, 2014, 11:00:00 PM
Post by: AnilG on March 19, 2014, 11:00:00 PM
Empty and Disable Cache in your Browser when you are downloading file. The browser is caching file, on repeat requests browser is checking if cached file has changed before initiating download. It most probably taking up a few extra precious seconds.
from: RaymondG on March 20, 2014, 12:41:45 AM
from: RaymondG on March 20, 2014, 12:41:45 AM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 19, 2014, 11:00:00 PM
Post by: TravelingPennies on March 19, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: RaymondG on March 19, 2014, 11:00:00 PM
Post by: RaymondG on March 19, 2014, 11:00:00 PM
I could not figure out why browseNotes.csv was downloaded in 3 seconds in a few seconds ago then it took 20+ seconds to download the file. I monitored the Network connection activity. It seems like the speed for downloading browseNots.csv was capped at about 42kB/s at most times. The speed was above 500KB/s when I downloaded large files from other web sites for test immediately. Does Lending club have restriction on bandwidth of downloading?
Starting from the right of the attached screen shot, the first two spikes in network activities corresponds to downloads within 3 seconds. The third and flat shape shows that browseNotes.csv was downloaded at 42KB/s with total 20+ seconds being taken
Starting from the right of the attached screen shot, the first two spikes in network activities corresponds to downloads within 3 seconds. The third and flat shape shows that browseNotes.csv was downloaded at 42KB/s with total 20+ seconds being taken
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 20, 2014, 11:00:00 PM
Post by: TravelingPennies on March 20, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 28, 2014, 11:00:00 PM
Post by: TravelingPennies on March 28, 2014, 11:00:00 PM
Finally find a solution after numerous search and tries. It passed several tests in a row. Looking forward how it will do in real runs.
Title: Automatically downloading notes.csv file: anyone know how to
Post by: core on March 28, 2014, 11:00:00 PM
Post by: core on March 28, 2014, 11:00:00 PM
Raymond-
If you had find solution please tell so other browser see.
If you had find solution please tell so other browser see.
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 28, 2014, 11:00:00 PM
Post by: TravelingPennies on March 28, 2014, 11:00:00 PM
I will share if it could pass every run in several days. Cross my fingers...
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 28, 2014, 11:00:00 PM
Post by: TravelingPennies on March 28, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: Fred on March 29, 2014, 11:00:00 PM
Post by: Fred on March 29, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on March 29, 2014, 11:00:00 PM
Post by: TravelingPennies on March 29, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on June 08, 2014, 11:00:00 PM
Post by: TravelingPennies on June 08, 2014, 11:00:00 PM
The downloading is much faster using the new Download All link (file is secure-primaryMarketNotes-browseNotes_1-RETAIL.csv). I have experienced shorter downloading time from 3 to 5 seconds instead of 20+ seconds at most times in the past. LC finally improved this little thing. Thanks.
Title: Automatically downloading notes.csv file: anyone know how to
Post by: Fred93 on June 08, 2014, 11:00:00 PM
Post by: Fred93 on June 08, 2014, 11:00:00 PM
Title: Automatically downloading notes.csv file: anyone know how to
Post by: brycemason on June 09, 2014, 11:00:00 PM
Post by: brycemason on June 09, 2014, 11:00:00 PM
Woo woo. I feel special:
https://resources.lendingclub.com/secure/primaryMarketNotes/browseNotes_1-INSTITUTIONAL.csv
Guessing this just means I have whole loan access, which anyone can get.
https://resources.lendingclub.com/secure/primaryMarketNotes/browseNotes_1-INSTITUTIONAL.csv
Guessing this just means I have whole loan access, which anyone can get.
Title: Automatically downloading notes.csv file: anyone know how to
Post by: TravelingPennies on June 10, 2014, 11:00:00 PM
Post by: TravelingPennies on June 10, 2014, 11:00:00 PM