15 New Messages
Digest #2551
Messages
Mon Mar 18, 2013 6:22 am (PDT) . Posted by:
"Mark" mballard34a
Yes, I did log in before, but the issue was the recalculation - I ran the macro and it cleared up the problem
Thank you.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Did you log in BEFORE you used the function? Otherwise, you'll still have
> the pre-login web page stored in the add-in. You'd need to use the
> smfForceRecalculation macro to purge the saved web page and get a new one.
> See the LINKS area of the group for more info on that macro.
>
> Another possibility is that EXCEL uses a different version of IE than the
> one you use as a browser. It's one reason I suggest people log in using the
> EXCEL Web Query dialog instead of with their browser.
>
> On Fri, Mar 15, 2013 at 11:40 AM, Mark <ballard@...> wrote:
>
> >
> > None of the Morningstar elements that I use are retrieving data, for
> > example, =RCHGetElementNumber(Ticker,881)which normally grabs the Growth
> > Grade or =RCHGetElementNumber(Ticker,877)which normally grabs the Industry
> > name.
> >
> > I am just getting "Error" in the cell.
> >
> > I looked to see if there was an update in the Work In Progress folder and
> > didn't see one. I also note that there are issues with the RCHGet
> > TableCell functions that use the Morningstar Quicktake pages (I've updated
> > my spreadsheet for the new Template that was uploaded recently.
> >
> > Any thoughts?
> >
> > I have my Premium Morningstar subscription open in an IE window and am
> > logged in - and that IE has the security setting at the level that accepts
> > all cookies.
> >
>
Thank you.
--- In smf_addin@yahoogrou
>
> Did you log in BEFORE you used the function? Otherwise, you'll still have
> the pre-login web page stored in the add-in. You'd need to use the
> smfForceRecalculati
> See the LINKS area of the group for more info on that macro.
>
> Another possibility is that EXCEL uses a different version of IE than the
> one you use as a browser. It's one reason I suggest people log in using the
> EXCEL Web Query dialog instead of with their browser.
>
> On Fri, Mar 15, 2013 at 11:40 AM, Mark <ballard@
>
> >
> > None of the Morningstar elements that I use are retrieving data, for
> > example, =RCHGetElementNumbe
> > Grade or =RCHGetElementNumbe
> > name.
> >
> > I am just getting "Error" in the cell.
> >
> > I looked to see if there was an update in the Work In Progress folder and
> > didn't see one. I also note that there are issues with the RCHGet
> > TableCell functions that use the Morningstar Quicktake pages (I've updated
> > my spreadsheet for the new Template that was uploaded recently.
> >
> > Any thoughts?
> >
> > I have my Premium Morningstar subscription open in an IE window and am
> > logged in - and that IE has the security setting at the level that accepts
> > all cookies.
> >
>
Mon Mar 18, 2013 7:03 am (PDT) . Posted by:
"kgotatoudji" kgotatoudji
Hi Randy.
I'll like to start playing a little with the functions of your AddIn.
Can you please give me the link to the download section?
TIA,
Raymond
Mon Mar 18, 2013 8:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's the "Add-in" folder in the FILES area of the group.
On Mon, Mar 18, 2013 at 6:50 AM, kgotatoudji <rgotatoudji@hotmail.com >wrote:
>
> I'll like to start playing a little with the functions of your AddIn.
> Can you please give me the link to the download section?
>
On Mon, Mar 18, 2013 at 6:50 AM, kgotatoudji <rgotatoudji@
>
> I'll like to start playing a little with the functions of your AddIn.
> Can you please give me the link to the download section?
>
Mon Mar 18, 2013 8:34 am (PDT) . Posted by:
"Jerry" jerryhofac1
Hello:
Question: Do these add-ins work with the free OpenOffice software ??
Thank you.
Question: Do these add-ins work with the free OpenOffice software ??
Thank you.
Mon Mar 18, 2013 8:48 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
To quote from the front page of the group:
"No Mac. No Open Office."
On Mon, Mar 18, 2013 at 8:16 AM, Jerry <jerryhofac1@yahoo.com > wrote:
>
> Question: Do these add-ins work with the free OpenOffice software ??
>
"No Mac. No Open Office."
On Mon, Mar 18, 2013 at 8:16 AM, Jerry <jerryhofac1@
>
> Question: Do these add-ins work with the free OpenOffice software ??
>
Mon Mar 18, 2013 10:29 am (PDT) . Posted by:
"andyha8" andyha8
I have an Athlon II 620. I find it very slow when making my spreadsheet calculations. Is it my CPU or is the process just slow? I am thinking of getting a core i7. Do you think this would improve the excel calculation speed? What are people's experiences with this.
Thanks everyone
Thanks everyone
Mon Mar 18, 2013 12:27 pm (PDT) . Posted by:
"Au" uanant@ymail.com
I was trying to download this spreadsheet
10 Year Financial Summary.xls
10 Year Financial Summary.xlsx
created by "mrpatmcginnis"
I got an error message "This document is not accessible"
I would appreciate your help
regards
Aku
10 Year Financial Summary.xls
10 Year Financial Summary.xlsx
created by "mrpatmcginnis
I got an error message "This document is not accessible"
I would appreciate your help
regards
Aku
Mon Mar 18, 2013 1:54 pm (PDT) . Posted by:
"Mark Knecht" mw_knecht
On Mon, Mar 18, 2013 at 12:27 PM, Au <uanant@ymail.com > wrote:
>
>
>
> I was trying to download this spreadsheet
> 10 Year Financial Summary.xls
> 10 Year Financial Summary.xlsx
>
> created by "mrpatmcginnis"
> I got an error message "This document is not accessible"
>
> I would appreciate your help
>
> regards
> Aku
Me too. I was just going to report the same issue. I can't seem to get
any file to download at the moment.
Thanks,
Mark
>
>
>
> I was trying to download this spreadsheet
> 10 Year Financial Summary.xls
> 10 Year Financial Summary.xlsx
>
> created by "mrpatmcginnis
> I got an error message "This document is not accessible"
>
> I would appreciate your help
>
> regards
> Aku
Me too. I was just going to report the same issue. I can't seem to get
any file to download at the moment.
Thanks,
Mark
Mon Mar 18, 2013 1:54 pm (PDT) . Posted by:
"Mark Knecht" mw_knecht
Seems to be working now...
- Mark
On Mon, Mar 18, 2013 at 12:30 PM, Mark Knecht <markknecht@gmail.com > wrote:
> On Mon, Mar 18, 2013 at 12:27 PM, Au <uanant@ymail.com > wrote:
>>
>>
>>
>> I was trying to download this spreadsheet
>> 10 Year Financial Summary.xls
>> 10 Year Financial Summary.xlsx
>>
>> created by "mrpatmcginnis"
>> I got an error message "This document is not accessible"
>>
>> I would appreciate your help
>>
>> regards
>> Aku
>
> Me too. I was just going to report the same issue. I can't seem to get
> any file to download at the moment.
>
> Thanks,
> Mark
- Mark
On Mon, Mar 18, 2013 at 12:30 PM, Mark Knecht <markknecht@gmail.
> On Mon, Mar 18, 2013 at 12:27 PM, Au <uanant@ymail.
>>
>>
>>
>> I was trying to download this spreadsheet
>> 10 Year Financial Summary.xls
>> 10 Year Financial Summary.xlsx
>>
>> created by "mrpatmcginnis
>> I got an error message "This document is not accessible"
>>
>> I would appreciate your help
>>
>> regards
>> Aku
>
> Me too. I was just going to report the same issue. I can't seem to get
> any file to download at the moment.
>
> Thanks,
> Mark
Mon Mar 18, 2013 2:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
From time to time, the Yahoo servers are down for a short while, and you'll
get either that message, or something similar. I usually just try again a
little later on.
On Mon, Mar 18, 2013 at 12:27 PM, Au <uanant@ymail.com > wrote:
>
> I was trying to download this spreadsheet
> 10 Year Financial Summary.xls
> 10 Year Financial Summary.xlsx
>
> created by "mrpatmcginnis"
> I got an error message "This document is not accessible"
>
> I would appreciate your help
>
>
get either that message, or something similar. I usually just try again a
little later on.
On Mon, Mar 18, 2013 at 12:27 PM, Au <uanant@ymail.
>
> I was trying to download this spreadsheet
> 10 Year Financial Summary.xls
> 10 Year Financial Summary.xlsx
>
> created by "mrpatmcginnis
> I got an error message "This document is not accessible"
>
> I would appreciate your help
>
>
Mon Mar 18, 2013 12:39 pm (PDT) . Posted by:
"Jovica Bozic" jovica.bozic
I did everything you told me except number 4."Added references for the Visual Basic for Applications and Microsoft XML libraries" which I don't understand. My knowledge here is insufficient.
Without number 4. I get this error : compile error usern-defined type not defined in RCHGetURLData1 function line : Dim oHTTP As New XMLHTTP.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Here's what I did:
>
> 1. Exported the modCovertData, modUtilities, and modGetTagContent
> modules from the add-in.
> 2. Open a new workbook
> 3. Imported those three exported modules into the VBA environment for
> the new workbook
> 4. Added references for the Visual Basic for Applications and Microsoft
> XML libraries
>
> From there, it appeared to work...
> On Sun, Mar 17, 2013 at 5:42 AM, Jovica Bozic <jovica.bozic@...>wrote:
>
> > If someone could help me to isolate smfGetTagContent function so that
> > Excel file could function without addin (standalone smfGetTagContent file).
> > I've copied all necessary functions into VBA, but when I try to use
> > smfGetTagContent I get error in smfConvertData line in smfGetTagContent
> > function even if smfConvertData function is also in VBA.
> >
>
Without number 4. I get this error : compile error usern-defined type not defined in RCHGetURLData1 function line : Dim oHTTP As New XMLHTTP.
--- In smf_addin@yahoogrou
>
> Here's what I did:
>
> 1. Exported the modCovertData, modUtilities, and modGetTagContent
> modules from the add-in.
> 2. Open a new workbook
> 3. Imported those three exported modules into the VBA environment for
> the new workbook
> 4. Added references for the Visual Basic for Applications and Microsoft
> XML libraries
>
> From there, it appeared to work...
> On Sun, Mar 17, 2013 at 5:42 AM, Jovica Bozic <jovica.bozic@
>
> > If someone could help me to isolate smfGetTagContent function so that
> > Excel file could function without addin (standalone smfGetTagContent file).
> > I've copied all necessary functions into VBA, but when I try to use
> > smfGetTagContent I get error in smfConvertData line in smfGetTagContent
> > function even if smfConvertData function is also in VBA.
> >
>
Mon Mar 18, 2013 2:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
While in the VBA environment for your worksheet, you need to use the >
Tools > References menu option and tell it which external load libraries to
use.
Here is the list I use with the add-in:
http://finance.groups.yahoo.com/group/smf_addin/message/10140
But I don't think you need all of them for the functions you're using. The
compile error you're getting is because the XML library is missing.
On Mon, Mar 18, 2013 at 12:39 PM, Jovica Bozic <jovica.bozic@yahoo.com >wrote:
> I did everything you told me except number 4."Added references for the
> Visual Basic for Applications and Microsoft XML libraries" which I don't
> understand. My knowledge here is insufficient.
>
> Without number 4. I get this error : compile error usern-defined type not
> defined in RCHGetURLData1 function line : Dim oHTTP As New XMLHTTP.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Here's what I did:
> >
> > 1. Exported the modCovertData, modUtilities, and modGetTagContent
> > modules from the add-in.
> > 2. Open a new workbook
> > 3. Imported those three exported modules into the VBA environment for
> > the new workbook
> > 4. Added references for the Visual Basic for Applications and
> Microsoft
> > XML libraries
> >
> > From there, it appeared to work...
>
Tools > References menu option and tell it which external load libraries to
use.
Here is the list I use with the add-in:
http://finance.
But I don't think you need all of them for the functions you're using. The
compile error you're getting is because the XML library is missing.
On Mon, Mar 18, 2013 at 12:39 PM, Jovica Bozic <jovica.bozic@
> I did everything you told me except number 4."Added references for the
> Visual Basic for Applications and Microsoft XML libraries" which I don't
> understand. My knowledge here is insufficient.
>
> Without number 4. I get this error : compile error usern-defined type not
> defined in RCHGetURLData1 function line : Dim oHTTP As New XMLHTTP.
>
> --- In smf_addin@yahoogrou
> >
> > Here's what I did:
> >
> > 1. Exported the modCovertData, modUtilities, and modGetTagContent
> > modules from the add-in.
> > 2. Open a new workbook
> > 3. Imported those three exported modules into the VBA environment for
> > the new workbook
> > 4. Added references for the Visual Basic for Applications and
> Microsoft
> > XML libraries
> >
> > From there, it appeared to work...
>
Mon Mar 18, 2013 12:50 pm (PDT) . Posted by:
"Brett" bpeven
Does that mean I can't extract from that page anymore?
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I can't even open the gurufocus web site with IE, so I can't be of much
> help.
>
> With FireFox, I did need to log in to get to one of the URLs you use:
>
> http://www.gurufocus.com/holdings.php?GuruName=AndreasHalvorsen&sort=position&p=4&ind=120
>
> But I need to click on a link from that page to get the actual holdings.
>
> On Fri, Mar 15, 2013 at 2:47 PM, Brett <bpeven@...> wrote:
>
> > I can't figure out how to get this spreadsheet that extracts holdings from
> > Gurufocus.com to work anymore.
> >
> >
> > http://f1.grp.yahoofs.com/v1/mJZDUY1U4DJcWV6hKhlL4U_S91uIJZloQ2HYOO7s7Pq6rC54Ez9rePBfKPd-ZU3xgraSEJ5SyFgZSuYVYjX1PME4cpkT/Uploads%20by%20forum%20members/Guru%20Industry%20Report.xls
> >
>
Thanks
--- In smf_addin@yahoogrou
>
> I can't even open the gurufocus web site with IE, so I can't be of much
> help.
>
> With FireFox, I did need to log in to get to one of the URLs you use:
>
> http://www.gurufocu
>
> But I need to click on a link from that page to get the actual holdings.
>
> On Fri, Mar 15, 2013 at 2:47 PM, Brett <bpeven@.
>
> > I can't figure out how to get this spreadsheet that extracts holdings from
> > Gurufocus.com to work anymore.
> >
> >
> > http://f1.grp.
> >
>
Mon Mar 18, 2013 2:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They've changed the web page addresses, the web page layouts, and security
levels. I wasn't able to get the holdings pages to work, but the Latest
Trades pages appear to work (but only through the end of last year).
If you sign up for their service, the holdings can be downloaded as an
EXCEL file.
On Mon, Mar 18, 2013 at 12:50 PM, Brett <bpeven@yahoo.com > wrote:
> Does that mean I can't extract from that page anymore?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > I can't even open the gurufocus web site with IE, so I can't be of much
> > help.
> >
> > With FireFox, I did need to log in to get to one of the URLs you use:
> >
> >
> http://www.gurufocus.com/holdings.php?GuruName=AndreasHalvorsen&sort=position&p=4&ind=120
> >
> > But I need to click on a link from that page to get the actual holdings.
>
levels. I wasn't able to get the holdings pages to work, but the Latest
Trades pages appear to work (but only through the end of last year).
If you sign up for their service, the holdings can be downloaded as an
EXCEL file.
On Mon, Mar 18, 2013 at 12:50 PM, Brett <bpeven@yahoo.
> Does that mean I can't extract from that page anymore?
>
> --- In smf_addin@yahoogrou
> >
> > I can't even open the gurufocus web site with IE, so I can't be of much
> > help.
> >
> > With FireFox, I did need to log in to get to one of the URLs you use:
> >
> >
> http://www.gurufocu
> >
> > But I need to click on a link from that page to get the actual holdings.
>
Mon Mar 18, 2013 1:57 pm (PDT) . Posted by:
"friedman_steve" friedman_steve
Randy,
regarding the RCHGetYahooQuotes() function.
The documentation that lays out all the codes mentions that these are "Here is a table listing the most commonly used data codes:"
Are there more data codes for this? If so where?
I'm specifically trying to find code to download the Upcoming Earnings Date.
When i go directly the website: http://finance.yahoo.com/q?s=AAPL
I see it given as April 23.
The GetElementNumber 1285 code you have for upcoming earnings date references a different Yahoo site that doesn't always have the data (for example, with AAPL, it doesn't show up at (http://finance.yahoo.com/q/ae?s=aapl&ql=1 ) , while for IBM it does).
Is there a GetYahooQuote code to grab it?
BTW - Thanks you incredibly for all the help this provides. Your product is AMAZING.
Thanks,
Steve
regarding the RCHGetYahooQuotes(
The documentation that lays out all the codes mentions that these are "Here is a table listing the most commonly used data codes:"
Are there more data codes for this? If so where?
I'm specifically trying to find code to download the Upcoming Earnings Date.
When i go directly the website: http://finance.
I see it given as April 23.
The GetElementNumber 1285 code you have for upcoming earnings date references a different Yahoo site that doesn't always have the data (for example, with AAPL, it doesn't show up at (http://finance.
Is there a GetYahooQuote code to grab it?
BTW - Thanks you incredibly for all the help this provides. Your product is AMAZING.
Thanks,
Steve
Tidak ada komentar:
Posting Komentar