15 Messages
Digest #3019
Messages
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/10 year model - GuruFocus - All Types.xlsx
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : Uses GuruFocus data, should work for Financials as well as non-Financials
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/10%20year%20model%20-%20GuruFocus%20-%20All%20Types.xlsx
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
hamishthedenizen <dan-carroll@yahoo.com>
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/10 year model - GuruFocus - All Types.xlsx
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : Uses GuruFocus data, should work for Financials as well as non-Financials
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/10%20year%20model%20-%20GuruFocus%20-%20All%20Types.xlsx
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
hamishthedenizen <dan-carroll@yahoo.com>
Tue Mar 25, 2014 8:43 am (PDT) . Posted by:
hamishthedenizen
OK, I think I fixed it. Uploading the file now.
GuruFocus must have made a small alteration to their site again. The "All Types" sheet I try to position using the RCHGetTableCell prompts that you see in Column C. If the formatting of the site changes, those prompts won't work and the whole thing gets messed up. If I had more time maybe I'd come up with a more elegant solution than the ones I've used, but hopefully this version is more robust. I tested it on JPM, WFC and IBM and it seems to work. let me know if you have any more problems.
GuruFocus must have made a small alteration to their site again. The "All Types" sheet I try to position using the RCHGetTableCell prompts that you see in Column C. If the formatting of the site changes, those prompts won't work and the whole thing gets messed up. If I had more time maybe I'd come up with a more elegant solution than the ones I've used, but hopefully this version is more robust. I tested it on JPM, WFC and IBM and it seems to work. let me know if you have any more problems.
Tue Mar 25, 2014 8:49 am (PDT) . Posted by:
jaja3279
I am also having problems with RCHGetYahooHistory specifically when retrieving SPY quotes. In the same spreadsheet all other quotes work fine, but SPY comes up short by about 8 days for daily quotes and by 2 weeks for weekly quotes. Looks like the quote values are missing somewhere in between the date range - the beginning and ending quote values are correct, but the last few cells (eight in daily and two in weekly) are blank because that many data values are missing somewhere in the middle. Seems to be a problem on the Yahoo server.
Tue Mar 25, 2014 12:48 pm (PDT) . Posted by:
lewglenn
Randy,
Is there an alternate VBA call via Google to RCHGetYahooHistory?
Is there an alternate VBA call via Google to RCHGetYahooHistory?
Tue Mar 25, 2014 12:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can use the smfGetCSVFile() function with the Google CSV download link.
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792
On Tue, Mar 25, 2014 at 12:47 PM, <lewglenn@yahoo.com> wrote:
>
> Is there an alternate VBA call via Google to RCHGetYahooHistory?
>
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792
On Tue, Mar 25, 2014 at 12:47 PM, <lewglenn@yahoo.com> wrote:
>
> Is there an alternate VBA call via Google to RCHGetYahooHistory?
>
Tue Mar 25, 2014 1:17 pm (PDT) . Posted by:
lewglenn
I agree; it doesn't seem like a very good alternative to Yahoo's glitches.
But thanks!
But thanks!
Tue Mar 25, 2014 9:47 am (PDT) . Posted by:
jaja3279
Sorry for my ignorance, but is it possible to retrieve quotes from yahoo and google in the same spreadsheet? If yes, are there equivalents of RCHGetYahooHistory and smfPricesbyDates to retrieve from Google? Could someone point me to any documentation?
Tue Mar 25, 2014 11:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can use the add-in functions to retrieve data from any number of
sources in the same worksheet.
You'd need to use functions like RCHGetTableCell() or smfGetTagContent() or
smfGetOptionQuotes() to get data from Google. The documentation is now
found on the SMF add-in website:
http://ogres-crypt.com/SMF/Documentation/
There is a template in the FILES area of the Yahoo Group related to an
existing Google API for quotes:
RCHGetWebData-Google-API-Quotes.xls
Note that options data can be missing from Google. For example, right now
they have no option chains listed for IWM. And, Yahoo is missing a number
of them as well. Most noticeable for me is lack of option chains for SPY.
On Tue, Mar 25, 2014 at 9:47 AM, <karerat@yahoo.com> wrote:
>
> Sorry for my ignorance, but is it possible to retrieve quotes from yahoo
> and google in the same spreadsheet? If yes, are there equivalents of RCHGetYahooHistory
> and smfPricesbyDates to retrieve from Google? Could someone point me to any
> documentation?
>
sources in the same worksheet.
You'd need to use functions like RCHGetTableCell() or smfGetTagContent() or
smfGetOptionQuotes() to get data from Google. The documentation is now
found on the SMF add-in website:
http://ogres-crypt.com/SMF/Documentation/
There is a template in the FILES area of the Yahoo Group related to an
existing Google API for quotes:
RCHGetWebData-Google-API-Quotes.xls
Note that options data can be missing from Google. For example, right now
they have no option chains listed for IWM. And, Yahoo is missing a number
of them as well. Most noticeable for me is lack of option chains for SPY.
On Tue, Mar 25, 2014 at 9:47 AM, <karerat@yahoo.com> wrote:
>
> Sorry for my ignorance, but is it possible to retrieve quotes from yahoo
> and google in the same spreadsheet? If yes, are there equivalents of RCHGetYahooHistory
> and smfPricesbyDates to retrieve from Google? Could someone point me to any
> documentation?
>
Tue Mar 25, 2014 12:59 pm (PDT) . Posted by:
gurvich
Hi,
The following formula returns -- for any input in B13 (quarter end date, total revenue...)
smfGetAdvFNElement("AAPL","Q",COLUMNS($C:C),">"&$B13&"<",,"--")
I checked the previous conversations and the only answer I found is internet option settings but that didn't solve the problem. Does anybody have an idea of what it could be considering that the file works on another computer.
Thank you for your help
The following formula returns -- for any input in B13 (quarter end date, total revenue...)
smfGetAdvFNElement(
I checked the previous conversations and the only answer I found is internet option settings but that didn't solve the problem. Does anybody have an idea of what it could be considering that the file works on another computer.
Thank you for your help
Tue Mar 25, 2014 1:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The Internet Options would have been my first suggestion.
Are you using the smf-AdvFN-Prefix.txt file on the machine that works? Or
would there be any reason for AdvFN to redirect web pages on a regional
basis for one computer versus the other?
Are both machines running the same version of the add-in? I did have to
make changes to the add-in last year to allow AdvFN data retrievals to
continue working.
On Tue, Mar 25, 2014 at 12:56 PM, <alex@gurvich.net> wrote:
> The following formula returns -- for any input in B13 (quarter end date,
> total revenue...)
>
> smfGetAdvFNElement("AAPL","Q",COLUMNS($C:C),">"&$B13&"<",,"--")
>
> I checked the previous conversations and the only answer I found is
> internet option settings but that didn't solve the problem. Does anybody
> have an idea of what it could be considering that the file works on another
> computer.
>
>
Are you using the smf-AdvFN-Prefix.txt file on the machine that works? Or
would there be any reason for AdvFN to redirect web pages on a regional
basis for one computer versus the other?
Are both machines running the same version of the add-in? I did have to
make changes to the add-in last year to allow AdvFN data retrievals to
continue working.
On Tue, Mar 25, 2014 at 12:56 PM, <alex@gurvich.net> wrote:
> The following formula returns -- for any input in B13 (quarter end date,
> total revenue...)
>
> smfGetAdvFNElement(
>
> I checked the previous conversations and the only answer I found is
> internet option settings but that didn't solve the problem. Does anybody
> have an idea of what it could be considering that the file works on another
> computer.
>
>
Tue Mar 25, 2014 1:13 pm (PDT) . Posted by:
"Nikola Ganev" ganevniko
Thanks Randy. I am trying to find smf-AdvFN-Prefix.txt file, but did not find it. Also, the other machine does not have this file.
Thank you very much
On Tuesday, March 25, 2014 4:02 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
The Internet Options would have been my first suggestion.
Are you using the smf-AdvFN-Prefix.txt file on the machine that works? Or would there be any reason for AdvFN to redirect web pages on a regional basis for one computer versus the other?
Are both machines running the same version of the add-in? I did have to make changes to the add-in last year to allow AdvFN data retrievals to continue working.
On Tue, Mar 25, 2014 at 12:56 PM, <alex@gurvich.net> wrote:
The following formula returns -- for any input in B13 (quarter end date, total revenue...)
>smfGetAdvFNElement("AAPL","Q",COLUMNS($C:C),">"&$B13&"<",,"--")
>I checked the previous conversations and the only answer I found is internet option settings but that didn't solve the problem. Does anybody have an idea of what it could be considering that the file works on another computer.
>
Thank you very much
On Tuesday, March 25, 2014 4:02 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
The Internet Options would have been my first suggestion.
Are you using the smf-AdvFN-Prefix.txt file on the machine that works? Or would there be any reason for AdvFN to redirect web pages on a regional basis for one computer versus the other?
Are both machines running the same version of the add-in? I did have to make changes to the add-in last year to allow AdvFN data retrievals to continue working.
On Tue, Mar 25, 2014 at 12:56 PM, <alex@gurvich.net> wrote:
The following formula returns -- for any input in B13 (quarter end date, total revenue...)
>smfGetAdvFNElem
>I checked the previous conversations and the only answer I found is internet option settings but that didn't solve the problem. Does anybody have an idea of what it could be considering that the file works on another computer.
>
Tue Mar 25, 2014 1:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It would only exist if you had created it (in the folder with the add-in).
On Tue, Mar 25, 2014 at 1:11 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
> I am trying to find smf-AdvFN-Prefix.txt file, but did not find it. Also,
> the other machine does not have this file.
>
On Tue, Mar 25, 2014 at 1:11 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
> I am trying to find smf-AdvFN-Prefix.
> the other machine does not have this file.
>
Tue Mar 25, 2014 1:37 pm (PDT) . Posted by:
"Nikola Ganev" ganevniko
Sorry Randy, I don't understand, how do I create it?
And just wondering why would it work on the other machine that does not have that smf-AdvFN-Prefix.txt file...
Thank you
On Tuesday, March 25, 2014 4:20 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
It would only exist if you had created it (in the folder with the add-in).
On Tue, Mar 25, 2014 at 1:11 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
>I am trying to find smf-AdvFN-Prefix.txt file, but did not find it. Also, the other machine does not have this file.
>
And just wondering why would it work on the other machine that does not have that smf-AdvFN-Prefix.txt file...
Thank you
On Tuesday, March 25, 2014 4:20 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
It would only exist if you had created it (in the folder with the add-in).
On Tue, Mar 25, 2014 at 1:11 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
>I am trying to find smf-AdvFN-
>
Tue Mar 25, 2014 12:51 pm (PDT) . Posted by:
almondtree
=RCHCreateComment([@Ticker],G$3) I usually update these on Friday works for me P&F don't change that much. I use a column header G$3 (2 or 4) for each row then if you want candlesticks use 4 instead of a two.
Tue Mar 25, 2014 1:05 pm (PDT) . Posted by:
"Nikola Ganev" ganevniko
Hi again Randy,
I have a problem with the smfGetAdvFNElement formula, the following formula works on one computer and returns -- on another.
smfGetAdvFNElement("AAPL","Q",COLUMNS($C:C),">"&$B13&"<",,"--")
In B13 I tried different inputs like quarter end date, total revenue....
Do you have an idea what the problem could be ?
Thank you for your help
On Monday, March 24, 2014 1:58 AM, Randy Harmelink <rharmelink@gmail.com> wrote:
See item 0.2 on the "Tips and FAQs" web page:
http://ogres-crypt.com/SMF/Tips-and-FAQs/
If you haven't used AdvFN data before, you may also want to review the two AdvFN entries on that web page.
On Sun, Mar 23, 2014 at 10:53 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
>
>
>I am trying to use these three templates and no of them work, it says #NAME? in all the cells.
>
>smfGetAdvFNElement-Template-All-Line-Items
>smfGetAdvFNElement-Template-Specific-Line-Items
>RCHGetHTMLTable-Template-MSN-Annual-Financials
>
>Any idea what it could be?
>
I have a problem with the smfGetAdvFNElement formula, the following formula works on one computer and returns -- on another.
smfGetAdvFNElement("AAPL","Q",COLUMNS($C:C),">"&$B13&"<",,"--")
In B13 I tried different inputs like quarter end date, total revenue....
Do you have an idea what the problem could be ?
Thank you for your help
On Monday, March 24, 2014 1:58 AM, Randy Harmelink <rharmelink@gmail.com> wrote:
See item 0.2 on the "Tips and FAQs" web page:
http://ogres-crypt.com/SMF/Tips-and-FAQs/
If you haven't used AdvFN data before, you may also want to review the two AdvFN entries on that web page.
On Sun, Mar 23, 2014 at 10:53 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
>
>
>I am trying to use these three templates and no of them work, it says #NAME? in all the cells.
>
>smfGetAdvFNElem
>smfGetAdvFNElem
>RCHGetHTMLTable
>
>Any idea what it could be?
>
Tidak ada komentar:
Posting Komentar