Thanks for your reply. It is just that when populating cells in array format, columns of maybe 30 cells takes like few seconds. But if the formula is not...
15258
justy_sports
Aug 1, 2011 7:21 pm
Is there a way to import corporate bond data from the FINRA website to EXCEL using this add in? I am just looking to import basic information like price,...
15259
Randy Harmelink
rharmelink
Aug 1, 2011 7:29 pm
That's because something like RCHGetYahooQuotes() can get multiple items of data on multiple stocks in a single Internet access. It's WHY the function is...
15260
rdenotari
Aug 1, 2011 7:54 pm
Hi everyone, I'm currently looking for a function to get the "Previous Report Date" I was using this function to get the "Next Report Date", however I can't...
15261
Randy Harmelink
rharmelink
Aug 1, 2011 8:51 pm
Try earnings.com: http://www.earnings.com/company.asp?client=cb&ticker=MMM Or, MSN has a "Stmt Source Date" on their financials: ...
15262
Randy Harmelink
rharmelink
Aug 1, 2011 8:53 pm
More details, such as a source URL. I have no idea what to look for on their web site. You might also search the message archives?...
15263
Robert de Notaristefani
rdenotari
Aug 1, 2011 9:13 pm
The MSN date works great. Thank you ________________________________ From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent: Monday,...
15264
justy_sports
Aug 1, 2011 9:24 pm
I am just looking to import a portfolio of bonds from the "Watchlist" feature on FINRA's website. http://cxa.marketwatch.com/finra/BondCenter/Watchlist.aspx I...
15265
Randy Harmelink
rharmelink
Aug 1, 2011 10:58 pm
Can't help there. I have nothing to extract......
15266
bushpilote
Aug 2, 2011 7:50 pm
Hi Randy, I'm trying to download financial statements from AdvFn.com through an excel macro (I am familiar with the...
15267
Randy Harmelink
rharmelink
Aug 2, 2011 8:36 pm
No idea, sorry....
15268
dguillett1
donaldb36
Aug 2, 2011 10:47 pm
I have an external query macro that uses With ss.QueryTables(1) .Connection = _ "URL;http://www.advfn.com/p.php?pid=financials&btn=s_ok&mode=&symbol=" & symbol...
15269
cocoaacc
Aug 3, 2011 1:37 am
Dear Randy, I am looking for historical intraday data for U.S. stock market index and U.S. stocks. I only know how to find daily historical data for U.S. stock...
15270
Randy Harmelink
rharmelink
Aug 3, 2011 2:17 am
Check out this template: RCHGetWebData-Template-BarChart-Quotes-Extract.xls...
15272
bushpilote
Aug 3, 2011 1:41 pm
Thanks to both of you for the feedback....
15273
dguillett1
donaldb36
Aug 3, 2011 1:50 pm
So how is it working for you now? From: bushpilote Sent: Wednesday, August 03, 2011 8:41 AM To: smf_addin@yahoogroups.com Subject: [smf_addin] Re: Downloading...
15274
GaryFera
Aug 3, 2011 2:47 pm
Randy, given a web address for a chart like the one below, is there a way to import that chart into Excel with SMF? Gary ...
15275
Carl Wells
cgrwells
Aug 3, 2011 3:17 pm
ps thanks for that quotes.pm suggestion ... I had come across it before some months ago but it left my stream of conciousness ... I think it could save me a...
15276
Carl Wells
cgrwells
Aug 3, 2011 3:17 pm
Hi Bartjan, I had to do exactly the same ... how did you go about it? I used stock exchange websites for my local exchange codes, then tried the exchange code...
15277
Carl Wells
cgrwells
Aug 3, 2011 3:18 pm
That would certainly be of interest to me too ... but suspect the information isn't freely available? Â certainly not for mid-small cap companies and surely...
15278
Carl Wells
cgrwells
Aug 3, 2011 3:18 pm
Thanks; I can become comfortable at programming in R, I gather its pretty simple (was thinking of exporting my outputs into R and generating regression charts...
15279
adam_sommers
Aug 3, 2011 4:05 pm
I just opened my spreadsheet with the add-in linked data, and all of sudden a ton of blank internet explorer windows (I pull over 100 pieces of data on 100...
15280
adam_sommers
Aug 3, 2011 4:47 pm
I am using the RCHGetElement function in Excel 2010, with Windows 7. An example of a popped up window:...
15281
Randy Harmelink
rharmelink
Aug 3, 2011 5:06 pm
Just use the RCHCreateComment() function: =RCHCreateComment(" http://chart.finance.yahoo.com/t?s=AAPL&lang=en-US®ion=US&width=300&height=180 ",99)...
15282
Randy Harmelink
rharmelink
Aug 3, 2011 5:12 pm
In theory, I wouldn't think that should be the add-in -- the add-in uses the XMLHTTP protocol, which just retrieves the source code of the web page. No scripts...
15283
GaryFera
Aug 3, 2011 7:38 pm
Wow, so easy. Thanks much....
15284
adam_sommers
Aug 3, 2011 8:18 pm
Randy, I finally got it to go through the calcs, and had to remove all of my RCHGetElementNumber formulas linked to Google Finance elements. I am now using...
15285
ciroverdi77
Aug 3, 2011 8:44 pm
Just signed up and unclear about navigating this service. I simply want to download historical data in ASCII or text format. Help welcome. I can be...
15286
Randy Harmelink
rharmelink
Aug 3, 2011 8:46 pm
Documentation is in the "Documentation" folder of the files area of the group. You'd need the Overview/Installation document and then the document on the...
15287
futants46and2
Aug 4, 2011 1:49 am
Hey Randy, I know this is off topic, I have been trying to create an If and AND formula that has 3 arguments and a different outcome for each argument. I think...
