4 Messages
Digest #4472
Messages
Sun Jan 27, 2019 11:05 am (PST) . Posted by:
"The Kuffels" kuffel
As I said in my prior email, I am again getting stock prices. SMF menu refresh is also available. But the RCH "Version" returns the long link address: Stock Market Functions add-in Version..........Windows (32-bit) NT 10.00; 16.0;;;1)
Same result in the test workbook which contains nothing but an RCH "Version" call.
This says I still have something wrong since "Version" worked correctly before.
Any ideas or should I just not worry about it until something else goes wrong
Thanks,
Tom
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Same result in the test workbook which contains nothing but an RCH "Version" call.
This says I still have something wrong since "Version" worked correctly before.
Any ideas or should I just not worry about it until something else goes wrong
Thanks,
Tom
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Sun Jan 27, 2019 11:38 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmm. Location problems? "Version" should be returning the location where
you told the add-in manager to get the add-in from?
Whenever a workbook with add-in functions is save, EXCEL saves the
hard-coded location to the add-in with each function. Later, when that
workbook is opened, it checks to see if the add-in is still in that
location. If it is, it uses that add-in. If the location doesn't match,
EXCEL leaves the hard-coded location on the formula and flats it as an
unresolved link. To fix that, you need to remove all of those hard-coded
locations in front of the functions. Easiest way is to run the smfFixLinks
macro.
Now, when that workbook is saved, EXCEL will save the new hard-coded
location of the add-in and all links should be resolved when it is opened
again (unless the add-in is moved again). Unfortunately, this will need to
be done with each workbook that was saved with the add-in in a different
location. It's just how EXCEL handles the situation.
On Sun, Jan 27, 2019 at 12:05 PM 'The Kuffels' kuffel@... wrote:
>
> As I said in my prior email, I am again getting stock prices. SMF menu
> refresh is also available. But the RCH "Version" returns the long link
> address: Stock Market Functions add-in Version..........Windows (32-bit) NT
> 10.00; 16.0;;;1)
>
> Same result in the test workbook which contains nothing but an RCH
> "Version" call.
>
> This says I still have something wrong since "Version" worked correctly
> before.
>
> Any ideas or should I just not worry about it until something else goes
> wrong
>
>
>
you told the add-in manager to get the add-in from?
Whenever a workbook with add-in functions is save, EXCEL saves the
hard-coded location to the add-in with each function. Later, when that
workbook is opened, it checks to see if the add-in is still in that
location. If it is, it uses that add-in. If the location doesn't match,
EXCEL leaves the hard-coded location on the formula and flats it as an
unresolved link. To fix that, you need to remove all of those hard-coded
locations in front of the functions. Easiest way is to run the smfFixLinks
macro.
Now, when that workbook is saved, EXCEL will save the new hard-coded
location of the add-in and all links should be resolved when it is opened
again (unless the add-in is moved again). Unfortunately, this will need to
be done with each workbook that was saved with the add-in in a different
location. It's just how EXCEL handles the situation.
On Sun, Jan 27, 2019 at 12:05 PM 'The Kuffels' kuffel@... wrote:
>
> As I said in my prior email, I am again getting stock prices. SMF menu
> refresh is also available. But the RCH "Version" returns the long link
> address: Stock Market Functions add-in Version.....
> 10.00; 16.0;;;1)
>
> Same result in the test workbook which contains nothing but an RCH
> "Version" call.
>
> This says I still have something wrong since "Version" worked correctly
> before.
>
> Any ideas or should I just not worry about it until something else goes
> wrong
>
>
>
Mon Jan 28, 2019 12:49 am (PST) . Posted by:
sri.yanto
hai randy
pardon me ...i want to ask about reuters
its there any way to extract this part
https://www.reuters.com/finance/stocks/company-officers/UNTR.JK https://www.reuters.com/finance/stocks/company-officers/UNTR.JK
particularly name and age part
i have been tried with :
=smfConvertData(smfStrExtr(RCHGetWebData("https://www.reuters.com/finance/stocks/company-officers/MAIN.JK",">Age<",250),">","<")) , its return "age", not the number
i tried to take a look IE, unfortunately i cant find any table
any suggestion?
Thanks randy...once again..thanks
pardon me ...i want to ask about reuters
its there any way to extract this part
https://www.reuters.com/finance/stocks/company-officers/UNTR.JK https://www.reuters.com/finance/stocks/company-officers/UNTR.JK
particularly name and age part
i have been tried with :
=smfConvertData(smfStrExtr(RCHGetWebData("https://www.reuters.com/finance/stocks/company-officers/MAIN.JK","
i tried to take a look IE, unfortunately i cant find any table
any suggestion?
Thanks randy...once again..thanks
Attachment(s) from
1 of 1 Photo(s)
Mon Jan 28, 2019 1:26 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I see four tables on the page. Try array-entering this over a range:
=RCHGetHTMLTable("
https://www.reuters.com/finance/stocks/company-officers/UNTR.JK",">Since")
One quick way to check for tables:
- Open SMF-Quick-Webpage-Examination.xls
- Go to the "By HTML Tag" worksheet
- Enter the URL in cell C7, "table" in cell C8, and leave cell C9 empty.
That should show you the source code for four tables.
- I see the ">Since" text in the first table, so then I go to the "table
extract" worksheet
- Enter the URL in cell C6, ">Since" in cell C7, -1 in cell C8, 1 in
cell C10, and leave C9 and C11 empty (these last four are the default
values).
An easy way to use the "table extract" worksheet to see whether each table
on the can be extracted is:
- Enter the URL in cell C6, leave C7, C9, and C11 empty, 1 in cell C8,
"=C8" in cell C10. Basically saying extract the first table on the page.
- Now you can increment the value in cell C8 to see each following
table. 2, 3, 4, ...
On Mon, Jan 28, 2019 at 1:49 AM sri.yanto@... wrote:
> pardon me ...i want to ask about reuters
>
> its there any way to extract this part
>
> https://www.reuters.com/finance/stocks/company-officers/UNTR.JK
>
> particularly name and age part
>
> i have been tried with :
>
> =smfConvertData(smfStrExtr(RCHGetWebData("
> https://www.reuters.com/finance/stocks/company-officers/MAIN.JK",">Age<",250),">","<"))
> , its return "age", not the number
>
> i tried to take a look IE, unfortunately i cant find any table
>
> any suggestion?
>
>
>
=RCHGetHTMLTable("
https://www.reuters.com/finance/stocks/company-officers/UNTR.JK",">Since")
One quick way to check for tables:
- Open SMF-Quick-Webpage-Examination.xls
- Go to the "By HTML Tag" worksheet
- Enter the URL in cell C7, "table" in cell C8, and leave cell C9 empty.
That should show you the source code for four tables.
- I see the ">Since" text in the first table, so then I go to the "table
extract" worksheet
- Enter the URL in cell C6, ">Since" in cell C7, -1 in cell C8, 1 in
cell C10, and leave C9 and C11 empty (these last four are the default
values).
An easy way to use the "table extract" worksheet to see whether each table
on the can be extracted is:
- Enter the URL in cell C6, leave C7, C9, and C11 empty, 1 in cell C8,
"=C8" in cell C10. Basically saying extract the first table on the page.
- Now you can increment the value in cell C8 to see each following
table. 2, 3, 4, ...
On Mon, Jan 28, 2019 at 1:49 AM sri.yanto@... wrote:
> pardon me ...i want to ask about reuters
>
> its there any way to extract this part
>
> https://www.reuters.com/finance/stocks/company-officers/UNTR.JK
>
> particularly name and age part
>
> i have been tried with :
>
> =smfConvertData(smfStrExtr(RCHGetWebData("
> https://www.reuters.com/finance/stocks/company-officers/MAIN.JK","
> , its return "age"
>
> i tried to take a look IE, unfortunately i cant find any table
>
> any suggestion?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar