8 Messages
Digest #3147
1b
Re: Problems with RCHGetYahooHistory after Windows Vista re-image us by "Randy Harmelink" rharmelink
Messages
Sun Aug 10, 2014 4:13 pm (PDT) . Posted by:
northern1012001
I had to re-image my computer after it was corrupted. I saved my Excel files to an external hard drive. After re-loading the old Excel files that were built around the SMF Add In and re-installing the SMF Add In I am now getting the #NAME? error.
The individual cells now display:
='C:\Program Files\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooHistory(G4,B6,B7,B8,B9,B10,B11,B12,"da",B14,B15,B16)
Any idea how I can fix this?
Many thanks,
The individual cells now display:
='C:\
Any idea how I can fix this?
Many thanks,
Sun Aug 10, 2014 4:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try running the smfFixLinks macro that is contained in the add-in.
You just need to remove the path location that prefixes the function. I
used to do it manually so often that I wrote the smfFixLinks macro.
On Sun, Aug 10, 2014 at 4:13 PM, craig.mckay@... wrote:
> I had to re-image my computer after it was corrupted. I saved my Excel
> files to an external hard drive. After re-loading the old Excel files that
> were built around the SMF Add In and re-installing the SMF Add In I am now
> getting the #NAME? error.
>
> The individual cells now display:
>
> ='C:\Program Files\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooHistory(G4,B6,B7,B8,B9,B10,B11,B12,"da",B14,B15,B16)
>
> Any idea how I can fix this?
>
>
>
You just need to remove the path location that prefixes the function. I
used to do it manually so often that I wrote the smfFixLinks macro.
On Sun, Aug 10, 2014 at 4:13 PM, craig.mckay@
> I had to re-image my computer after it was corrupted. I saved my Excel
> files to an external hard drive. After re-loading the old Excel files that
> were built around the SMF Add In and re-installing the SMF Add In I am now
> getting the #NAME? error.
>
> The individual cells now display:
>
> ='C:\
> Add-in\RCH_
>
> Any idea how I can fix this?
>
>
>
Sun Aug 10, 2014 5:13 pm (PDT) . Posted by:
northern1012001
I edited one of the worksheets manually and that did the trick. I have a multitude of other worksheets with the same problem so I will try running the macro.
Appreciate and thanks!
Appreciate and thanks!
Mon Aug 11, 2014 12:10 am (PDT) . Posted by:
lawleesh
Hi Randy
Could you pls help me with the formula from https://sg.finance.yahoo.com/q/hp?s=888.L https://sg.finance.yahoo.com/q/hp?s=888.L to retrieve the price in large bold print immediately after the name of company?
thanks
LL
Could you pls help me with the formula from https://sg.finance.yahoo.com/q/hp?s=888.L https://sg.finance.yahoo.com/q/hp?s=888.L to retrieve the price in large bold print immediately after the name of company?
thanks
LL
Mon Aug 11, 2014 12:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
These works for me right now:
=smfConvertData(smfGetTagContent("https://sg.finance.yahoo.com/q/hp?s=888.L
","span",1,"time_rtq_ticker"))
...or:
=smfConvertData(smfGetTagContent("https://sg.finance.yahoo.com/q/hp?s=888.L
","span",-1,"yfs_l84"))
HOWEVER -- Yahoo has changed the structure of that section of the web page
numerous times, breaking formulas I write. And, in some cases, the
structure even changes depending on whether the market is open, or whether
we're before the market opened or after the market closed.
So I've pretty much given up trying to come up with something reliable.
On Mon, Aug 11, 2014 at 12:10 AM, lawrence.leesh@...wrote:
> Could you pls help me with the formula from
> https://sg.finance.yahoo.com/q/hp?s=888.L to retrieve the price in large
> bold print immediately after the name of company?
>
=smfConvertData(smfGetTagContent("https://sg.finance.yahoo.com/q/hp?s=888.L
","span",1,"time_rtq_ticker"))
...or:
=smfConvertData(smfGetTagContent("https://sg.finance.yahoo.com/q/hp?s=888.L
","span",-1,"yfs_l84"))
HOWEVER -- Yahoo has changed the structure of that section of the web page
numerous times, breaking formulas I write. And, in some cases, the
structure even changes depending on whether the market is open, or whether
we're before the market opened or after the market closed.
So I've pretty much given up trying to come up with something reliable.
On Mon, Aug 11, 2014 at 12:10 AM, lawrence.leesh@...wrote:
> Could you pls help me with the formula from
> https://sg.finance.yahoo.com/q/hp?s=888.L to retrieve the price in large
> bold print immediately after the name of company?
>
Mon Aug 11, 2014 12:44 am (PDT) . Posted by:
lawleesh
Thanks Randy. Is there a more stable structure in another Yahoo page e.g. the Summary, Charts or Profile page?
Mon Aug 11, 2014 12:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
They use the same structure on each page I've looked at. I usually do it
off the Summary page.
It's not tough to figure out for any given page. It's just frustrating that
it changes.
On Mon, Aug 11, 2014 at 12:44 AM, lawrence.leesh@... wrote:
>
> Thanks Randy. Is there a more stable structure in another Yahoo page e.g.
> the Summary, Charts or Profile page?
>
off the Summary page.
It's not tough to figure out for any given page. It's just frustrating that
it changes.
On Mon, Aug 11, 2014 at 12:44 AM, lawrence.leesh@
>
> Thanks Randy. Is there a more stable structure in another Yahoo page e.g.
> the Summary, Charts or Profile page?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar