6 Messages
Digest #3284
3b
Re: I may have missed this but is there an issue with MSN and RCHGet by "Randy Harmelink" rharmelink
Messages
Fri Jan 2, 2015 1:10 pm (PST) . Posted by:
zzolaman
Has there been any response to this query? I too would like to know how to find non-adjusted closing prices...
Fri Jan 2, 2015 1:13 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The RCHGetYahooHistory() function can return either or both adjusted and
non-adjusted closing prices, as long as Yahoo carries them in CSV file
format.
On Fri, Jan 2, 2015 at 1:35 PM, trevor.mchaney@... wrote:
> Has there been any response to this query? I too would like to know how
> to find non-adjusted closing prices...
>
non-adjusted closing prices, as long as Yahoo carries them in CSV file
format.
On Fri, Jan 2, 2015 at 1:35 PM, trevor.mchaney@
> Has there been any response to this query? I too would like to know how
> to find non-adjusted closing prices...
>
Fri Jan 2, 2015 2:44 pm (PST) . Posted by:
analyst101010
Hi everybody
I think this has been gone over many times before...
...but a while back the default location for the SMF files was in C:/Program Files/SMF Add-In/
....and now most Templates reference "C:/SMF Add-In/
I've been cleaning up a lot of older junk and files which had cut/pasted references from older templates, and I find that now whenever I open Excel (Office 2007) it tells me it can't find the original SMF files in the old location.
IOW, i have to remove and reload the add-in reference location whenever I open Excel. Its annoying. Isn't there some setting deeper in Excel where i can tell it to stop looking in the old location? It seems to want to go back there whenever i use older templates.
Any help? Link to previous answer, thank in advance...
Happy New Year, Randy et al
I think this has been gone over many times before...
...but a while back the default location for the SMF files was in C:/Program Files/SMF Add-In/
....and now most Templates reference "C:/SMF Add-In/
I've been cleaning up a lot of older junk and files which had cut/pasted references from older templates, and I find that now whenever I open Excel (Office 2007) it tells me it can't find the original SMF files in the old location.
IOW, i have to remove and reload the add-in reference location whenever I open Excel. Its annoying. Isn't there some setting deeper in Excel where i can tell it to stop looking in the old location? It seems to want to go back there whenever i use older templates.
Any help? Link to previous answer, thank in advance...
Happy New Year, Randy et al
Fri Jan 2, 2015 3:13 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry about that -- I had to move my usage of the add-in to "C:/SMF
Add-In/" because the Vista operating system wouldn't let me save changes to
the XLA file when it was located in the "Program Files" folder.
However, you don't need to reload the add-in. If you have location errors,
just run the smfFixLinks macro. I use it quite a bit myself, so I have it
on a button on my Quick Access Toolbar (along the smfForceRecalculation and
smfUpdateDownloadTable).
The smfFixLinks macro basically just does a "find and replace all" on all
of the location prefixes in front of the add-in functions, removing them.
This leaves the add-in function, which EXCEL then finds via the add-in
manager setup.
EXCEL won't do it automatically, because it hard-codes the location of the
add-in function whenever a file is saved. When the file is later opened, if
it doesn't find the resource in that location, it tags it as an "unresolved
link". EXCEL doesn't know that it's an add-in reference unless the link is
resolved. So, kind of a "Catch 22" situation.
On Fri, Jan 2, 2015 at 3:44 PM, jfgilmore@... wrote:
>
> I think this has been gone over many times before...
>
> ...but a while back the default location for the SMF files was in
> C:/Program Files/SMF Add-In/
>
> ....and now most Templates reference "C:/SMF Add-In/
>
> I've been cleaning up a lot of older junk and files which had cut/pasted
> references from older templates, and I find that now whenever I open Excel
> (Office 2007) it tells me it can't find the original SMF files in the old
> location.
>
> IOW, i have to remove and reload the add-in reference location whenever I
> open Excel. Its annoying. Isn't there some setting deeper in Excel where i
> can tell it to stop looking in the old location? It seems to want to go
> back there whenever i use older templates.
>
> Any help? Link to previous answer, thank in advance...
>
Add-In/" because the Vista operating system wouldn't let me save changes to
the XLA file when it was located in the "Program Files" folder.
However, you don't need to reload the add-in. If you have location errors,
just run the smfFixLinks macro. I use it quite a bit myself, so I have it
on a button on my Quick Access Toolbar (along the smfForceRecalculati
smfUpdateDownloadTa
The smfFixLinks macro basically just does a "find and replace all" on all
of the location prefixes in front of the add-in functions, removing them.
This leaves the add-in function, which EXCEL then finds via the add-in
manager setup.
EXCEL won't do it automatically, because it hard-codes the location of the
add-in function whenever a file is saved. When the file is later opened, if
it doesn't find the resource in that location, it tags it as an "unresolved
link". EXCEL doesn't know that it's an add-in reference unless the link is
resolved. So, kind of a "Catch 22" situation.
On Fri, Jan 2, 2015 at 3:44 PM, jfgilmore@..
>
> I think this has been gone over many times before...
>
> ...but a while back the default location for the SMF files was in
> C:/Program Files/SMF Add-In/
>
> ....and now most Templates reference "C:/SMF Add-In/
>
> I've been cleaning up a lot of older junk and files which had cut/pasted
> references from older templates, and I find that now whenever I open Excel
> (Office 2007) it tells me it can't find the original SMF files in the old
> location.
>
> IOW, i have to remove and reload the add-in reference location whenever I
> open Excel. Its annoying. Isn't there some setting deeper in Excel where i
> can tell it to stop looking in the old location? It seems to want to go
> back there whenever i use older templates.
>
> Any help? Link to previous answer, thank in advance...
>
Fri Jan 2, 2015 9:19 pm (PST) . Posted by:
blm3@sbcglobal.net
RCHGetElementNumber generates and uses the link
'http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=T"
but that link takes me to the home page ("http://www.msn.com/en-us/money"). This link sends me to the stock page
"http://www.msn.com/en-us/money/stockdetails/fi-126.1.T.NYS?symbol=T&form=PRFISB"
but the layout looks like it is very different(?). And if I use an ETF instead, it takes me to
"http://www.msn.com/en-us/money/etfdetails/fi-126.1.IDU.ARCX?symbol=IDU&form=PRFISB"
It looks like MSN has changed its layout and SMF has not yet caught up? and element 13862 may not still be SEF since the link has to go to one of the two pages URLs?
Thank you for your time.
'http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=T"
but that link takes me to the home page ("http://www.msn.com/en-us/money"). This link sends me to the stock page
"http://www.msn.com/en-us/money/stockdetails/fi-126.1.T.NYS?symbol=T&form=PRFISB"
but the layout looks like it is very different(?). And if I use an ETF instead, it takes me to
"http://www.msn.com/en-us/money/etfdetails/fi-126.1.IDU.ARCX?symbol=IDU&form=PRFISB"
It looks like MSN has changed its layout and SMF has not yet caught up? and element 13862 may not still be SEF since the link has to go to one of the two pages URLs?
Thank you for your time.
Fri Jan 2, 2015 9:40 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yes, you did miss something -- back at the end of September:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031
Bottom line -- all MSN data is currently obsolete. The web pages I get
using the add-in have even less data on them then what I can see in FireFox
or Chrome.
On Fri, Jan 2, 2015 at 10:19 PM, blm3@... wrote:
> RCHGetElementNumber generates and uses the link
>
> '
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=T"
>
>
> but that link takes me to the home page ("http://www.msn.com/en-us/money").
> This link sends me to the stock page
>
> "
> http://www.msn.com/en-us/money/stockdetails/fi-126.1.T.NYS?symbol=T&form=PRFISB
> "
>
> but the layout looks like it is very different(?). And if I use an ETF
> instead, it takes me to
>
> "
> http://www.msn.com/en-us/money/etfdetails/fi-126.1.IDU.ARCX?symbol=IDU&form=PRFISB
> "
>
> It looks like MSN has changed its layout and SMF has not yet caught up?
> and element 13862 may not still be SEF since the link has to go to one of
> the two pages URLs?
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031
Bottom line -- all MSN data is currently obsolete. The web pages I get
using the add-in have even less data on them then what I can see in FireFox
or Chrome.
On Fri, Jan 2, 2015 at 10:19 PM, blm3@... wrote:
> RCHGetElementNumber generates and uses the link
>
> '
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=T"
>
>
> but that link takes me to the home page ("http://www.msn.com/en-us/money").
> This link sends me to the stock page
>
> "
> http://www.msn.com/en-us/money/stockdetails/fi-126.1.T.NYS?symbol=T&form=PRFISB
> "
>
> but the layout looks like it is very different(?). And if I use an ETF
> instead, it takes me to
>
> "
> http://www.msn.com/en-us/money/etfdetails/fi-126.1.IDU.ARCX?symbol=IDU&form=PRFISB
> "
>
> It looks like MSN has changed its layout and SMF has not yet caught up?
> and element 13862 may not still be SEF since the link has to go to one of
> the two pages URLs?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar