8 New Messages
Digest #2831
Messages
Tue Oct 29, 2013 1:20 am (PDT) . Posted by:
lawrence.leesh
Thanks Randy. It worked but not very consistent. The "td" works if it is a positive number and "span" if it is a negative number.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
No, you got back what you should have. That's what the RCHGetTableCell() function does. It starts with that string, removes all of the HTML markup code, and then attempts to convert what is left into a number, adjusting as necessary for the magnitude suffixes.
So you would need to do that processing yourself after grabbing the raw contents of the table cell, as necessary.
In this particular case, you could grab the content of the "span" tag inside that "td" tag, but I'm not sure how consistent that will be on the web page:
=smfGetTagContent("http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG","span",1,"Non Operating Income/Expense";)
On Mon, Oct 28, 2013 at 11:38 PM, <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:
I tried =smfGetTagContent("http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG","td",1,"Non Operating Income/Expense";) and got <span class="mark... as the result.
Should it be something other than "td"? I modified this formula from an earlier conversation.
---In smf_addin@yahoogrou
No, you got back what you should have. That's what the RCHGetTableCell(
So you would need to do that processing yourself after grabbing the raw contents of the table cell, as necessary.
In this particular case, you could grab the content of the "span" tag inside that "td" tag, but I'm not sure how consistent that will be on the web page:
=smfGetTagContent(
On Mon, Oct 28, 2013 at 11:38 PM, <lawrence.
I tried =smfGetTagContent(
Should it be something other than "td"
Tue Oct 29, 2013 11:43 am (PDT) . Posted by:
rcstrauss
I have updated to the latest version of the add-in and most AdvFN element numbers seem to work. I am having trouble with 8066 -- it returns a letter (Q) instead of an integer like 1,2,3 or 4. Elements 8067, 8068 return numbers - is there a fix for 8066?
Thanks
Thanks
Tue Oct 29, 2013 11:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
A fix would have to come from AdvFN. I looked at several companies with my
browser, and they had "Q" posted for the most recent quarter. So the add-in
is just retrieving what AdvFN is posting.
BTW, you should have given me a sample ticker. It might have been an
isolated instance applying to only a few companies instead of all of them.
And I would have had nothing to look at.
On Tue, Oct 29, 2013 at 11:43 AM, <rcstrauss@yahoo.com> wrote:
> I have updated to the latest version of the add-in and most AdvFN
> element numbers seem to work. I am having trouble with 8066 -- it returns a
> letter (Q) instead of an integer like 1,2,3 or 4. Elements 8067, 8068
> return numbers - is there a fix for 8066?
>
browser, and they had "Q" posted for the most recent quarter. So the add-in
is just retrieving what AdvFN is posting.
BTW, you should have given me a sample ticker. It might have been an
isolated instance applying to only a few companies instead of all of them.
And I would have had nothing to look at.
On Tue, Oct 29, 2013 at 11:43 AM, <rcstrauss@yahoo.
> I have updated to the latest version of the add-in and most AdvFN
> element numbers seem to work. I am having trouble with 8066 -- it returns a
> letter (Q) instead of an integer like 1,2,3 or 4. Elements 8067, 8068
> return numbers - is there a fix for 8066?
>
Tue Oct 29, 2013 1:41 pm (PDT) . Posted by:
jmart99
Randy,
I work on a computer that disables the use of add-in files. Is it possible to put the add-in into my spreadsheet? I used VBA to move the modules from the Add-in file to my spreadhsheet (or VBAProject to use what I think is the proper term) but I get Compile Error: User Defined type not defined in the modUtilities module, RCHGetURLData1 function on the line Dim oHTTP As New XMLHTTP.
Running a quick search, I couldn't find XMLHTTP defined anywhere throughout the Project. I moved 33 modules, but perhaps it is defined elsewhere? Or is there is a better way to accomplish this?
Thanks,
Josh
I work on a computer that disables the use of add-in files. Is it possible to put the add-in into my spreadsheet? I used VBA to move the modules from the Add-in file to my spreadhsheet (or VBAProject to use what I think is the proper term) but I get Compile Error: User Defined type not defined in the modUtilities module, RCHGetURLData1 function on the line Dim oHTTP As New XMLHTTP.
Running a quick search, I couldn't find XMLHTTP defined anywhere throughout the Project. I moved 33 modules, but perhaps it is defined elsewhere? Or is there is a better way to accomplish this?
Thanks,
Josh
Tue Oct 29, 2013 2:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to set a number of reference files for the add-in's VBA code to
run:
-- Microsoft XML (v3.0)
-- Microsoft HTML Object Library
-- Microsoft Internet Controls
That XMLHTTP object is part of the XML library above.
Since you don't have the add-in installed, the easiest process would have
been to:
1. Open the XLA file in EXCEL
2. Go into the VBA environment and find the VBA project
3. Select its "Workbook"; object
4. Set the "IsAddin" property to FALSE
5. Close the VBA enviroment
6. Save the now visible workbook as an XLS file
Then you have all of the VBA environment as-is, without needing to copy
anything, in a normal workbook. I just tried this, by first creating a copy
of the XLA file under a different name and then converting that into an XLS
file.
This is basically the reverse process of creating the add-in -- create a
workbook, add the VBA code, then set the "IsAddin" property to TRUE, which
makes all of the worksheets invisible (although any data in them would
still be available), then save it as an XLA file.
However, if you do want to use RCHGetElementNumber(), all of the
smf-elements-*.txt files will need to be in the same folder as your new XLS
file, because they contain all the element definitions.
On Tue, Oct 29, 2013 at 1:41 PM, <jmart99@yahoo.com> wrote:
> I work on a computer that disables the use of add-in files. Is it
> possible to put the add-in into my spreadsheet? I used VBA to move the
> modules from the Add-in file to my spreadhsheet (or VBAProject to use what
> I think is the proper term) but I get Compile Error: User Defined type not
> defined in the modUtilities module, RCHGetURLData1 function on the line Dim
> oHTTP As New XMLHTTP.
>
> Running a quick search, I couldn't find XMLHTTP defined anywhere
> throughout the Project. I moved 33 modules, but perhaps it is defined
> elsewhere? Or is there is a better way to accomplish this?
>
run:
-- Microsoft XML (v3.0)
-- Microsoft HTML Object Library
-- Microsoft Internet Controls
That XMLHTTP object is part of the XML library above.
Since you don't have the add-in installed, the easiest process would have
been to:
1. Open the XLA file in EXCEL
2. Go into the VBA environment and find the VBA project
3. Select its "Workbook"
4. Set the "IsAddin" property to FALSE
5. Close the VBA enviroment
6. Save the now visible workbook as an XLS file
Then you have all of the VBA environment as-is, without needing to copy
anything, in a normal workbook. I just tried this, by first creating a copy
of the XLA file under a different name and then converting that into an XLS
file.
This is basically the reverse process of creating the add-in -- create a
workbook, add the VBA code, then set the "IsAddin" property to TRUE, which
makes all of the worksheets invisible (although any data in them would
still be available), then save it as an XLA file.
However, if you do want to use RCHGetElementNumber
smf-elements-
file, because they contain all the element definitions.
On Tue, Oct 29, 2013 at 1:41 PM, <jmart99@yahoo.
> I work on a computer that disables the use of add-in files. Is it
> possible to put the add-in into my spreadsheet? I used VBA to move the
> modules from the Add-in file to my spreadhsheet (or VBAProject to use what
> I think is the proper term) but I get Compile Error: User Defined type not
> defined in the modUtilities module, RCHGetURLData1 function on the line Dim
> oHTTP As New XMLHTTP.
>
> Running a quick search, I couldn't find XMLHTTP defined anywhere
> throughout the Project. I moved 33 modules, but perhaps it is defined
> elsewhere? Or is there is a better way to accomplish this?
>
Tue Oct 29, 2013 7:20 pm (PDT) . Posted by:
"mpalmer@swbell.net" mpalmer@swbell.net
Have a sheet full of data from ADVFN and used to pull the data using RCHGetElement function. It quit working some time ago (getting "error" msg). I downloaded the new add in xla but that hasn't worked either. I can get a few of the functions to work on some of the elements but can't seem to get anything working for the ADVFN site. Have tried the smfGetAdvFNElement() function but no success ("error"). Any suggestions? Using Excel 2007.
Tue Oct 29, 2013 8:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you old usage of AdvFN require use of a regional prefix?
On Tue, Oct 29, 2013 at 7:20 PM, mpalmer@swbell.net <mpalmer@swbell.net>wrote:
> Have a sheet full of data from ADVFN and used to pull the data using
> RCHGetElement function. It quit working some time ago (getting "error"
> msg). I downloaded the new add in xla but that hasn't worked either. I
> can get a few of the functions to work on some of the elements but can't
> seem to get anything working for the ADVFN site. Have tried the
> smfGetAdvFNElement() function but no success ("error"). Any suggestions?
> Using Excel 2007.
>
On Tue, Oct 29, 2013 at 7:20 PM, mpalmer@swbell.
> Have a sheet full of data from ADVFN and used to pull the data using
> RCHGetElement function. It quit working some time ago (getting "error"
> msg). I downloaded the new add in xla but that hasn't worked either. I
> can get a few of the functions to work on some of the elements but can't
> seem to get anything working for the ADVFN site. Have tried the
> smfGetAdvFNElement(
> Using Excel 2007.
>
Tue Oct 29, 2013 8:00 pm (PDT) . Posted by:
clay.paschall
Unfortunately,it seems the elements from google/advFn no longer work. Is there an updated elements list or somewhere else for Stmt. of Cashflows information?
Tidak ada komentar:
Posting Komentar