2 New Messages

Digest #2945

Re: SMF Get .XLS ? by "Randy Harmelink" rharmelink

Re: SMF Get .XLS ? by herkshirebathaway

Messages

1a

Actually, no need for SMF -- EXCEL can refer to XLS files on the Internet
-- see:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/22983

However, it looks like the URL you cited *creates* the XLS file, instead of
being an actual address of a file. It created an XLS file that has a name
like this, which appears to be only temporary:

Stock_Dataset_GuruFocus_2014-01-27-20-23.xls

On Mon, Jan 27, 2014 at 7:17 PM, <j.zhen.yap@gmail.com> wrote:

>
> I have successfully got together a script that will login to the GF
> website automatically. Thank you for your pointers.
>
> I'm now putting together a GuruFocus model which I will upload when I have
> finished.
>
> Gurufocus offers very complete dataset for any stock which can be
> downloaded at the following URL
> http://www.gurufocus.com/download_dataset.php?symbol=ASX:SHV .
>
> The file is in .XLS format. Is the SMF addin capable of importing such a
> file directly from the web?
>
> Thank you for your time Randy, very excited about this project.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Re: SMF Get .XLS ?

Mon Jan 27, 2014 9:14 pm (PST) . Posted by:

herkshirebathaway

Thanks Randy, I've managed to get the code to the point where it can download and open the file in excel, however I am having trouble merging the downloaded workbook into the original workbook (there are multiple worksheets and I do not have any experience using loops)...