8 New Messages
Digest #2269
| 1a Re: Distribute Spreadsheet with SMF Add-In by "antonvanas1989" antonvanas1989 1b Re: Distribute Spreadsheet with SMF Add-In by "Randy Harmelink" rharmelink 1c Re: Distribute Spreadsheet with SMF Add-In by "antonvanas1989" antonvanas1989 1d Re: Distribute Spreadsheet with SMF Add-In by "Randy Harmelink" rharmelink 2a some symbols no longer working by "Ronald Ricker MD" rricker@pacbell.net 2b Re: some symbols no longer working by "Randy H" rharmelink 2c Re: some symbols no longer working by "Ronald Ricker MD" rricker@pacbell.net 2d Re: some symbols no longer working by "Randy Harmelink" rharmelink |
Sat Jul 7, 2012 9:02 am (PDT) . Posted by: "antonvanas1989" antonvanas1989
Randy isn't there a way to go around this error?
At this moment i use to vista pc's with everything the same. (Windows, Excel version and Location of files)
And still when i copy the workbook and vba's from one to another there is a "Hardcode" from the other pc..
Is the only way to solve this is using one of the points you described in your post above?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Unfortunately, this is a common situation when workbooks are shared. It
> occurs because when you save your EXCEL file,MicroSoft decided to save the
> hard-coded location of the add-in in the cell formula, so that EXCEL knows
> the function comes from an external source. Then, when the file is opened,
> EXCEL looks for that external source. If it finds it, it resolves the link
> and removes the hard-coded location -- all is well. However, if it doesn't
> find the external source, EXCEL marks it as an unresolved link, which makes
> the cell non-functional until the link error is resolved.
>
> As you note, a manual change, cell by cell, does fix the problem. If you
> check EXCEL's menus, you find a way to > Edit > Links, which is another way
> to solve the issue for an entire workbook. However, I've found it work
> differently on different versions of EXCEL and was not a reliable way to fix
> link errors.
>
> The quickest and most reliable way I've found to fix the issue is to do a
> "Find and Replace All" (keyboard shortcut Ctrl+H), replacing all hard-coded
> locations:
>
> 'C:\User Name\Application
> Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!
>
> ...with nothing. Once that is done and the file is saved, that person's
> hard-coded add-in location will be saved with the formulas, so that the next
> time they open the file on their computer, the links will be resolved
> automatically.
>
> It's one reason I tried to go with a standard folder for the location of the
> add-in in the installation instructions. If everyone used the same location,
> this would never be an issue.
>
> Unfortunately, even I had to violate that, because Vista wouldn't let me
> update the add-in's XLA file while it was located in a subdirectory of the
> "Program Files" folder. The "Find and Replace" process could be automated --
> I have a macro I manually run to do it as needed when I open files that used
> to use my old location:
>
> Public Sub smfFixLinks()
> ActiveSheet.Cells.Replace _
> What:="'C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!", _
> Replacement:="", _
> LookAt:=xlPart, _
> SearchOrder:=xlByRows, _
> MatchCase:=False, _
> SearchFormat:=False, _
> ReplaceFormat:=False
> End Sub
>
>
> On Wed, Aug 25, 2010 at 1:45 PM, Ping Zhu <p_zhu00@...> wrote:
>
> > This might be a pretty dumb question, but I've got an issue when I tried
> > to copy my working Excel model to my colleagues' computers. I installed
> > RCH_Stock_Market_Functions.xla as add-ins in my computer, and was able to
> > develop a model by placing the formulas in some cells directly (not in VBA
> > code). For example:
> >
> > In cell A1, I placed "=RCHGetElementNumber("YUM", 13862)", and I correctly
> > got the result as "YUM! BRANDS INC".
> >
> > Unfortunately, when I copy this same Excel file to another computer (with
> > SMF Add-Ins installed), the formula in cell A1 was automatically changed to
> > something like:
> >
> > ='C:\User Name\Application
> > Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber("YUM",
> > 13862)
> >
> > As a result, this cell no longer returns a valid result. If I manually
> > remove the path, it'll work fine in the new computer. However, this is very
> > tedious as I have many RCHGetElementNumber calls in lots of cells.
> >
> > I suspect I'm not installing the Excel add-in correctly? Is there a way so
> > that I can freely copy my finished models to other computers in the future,
> > without encountering the same problem?
> >
>
At this moment i use to vista pc's with everything the same. (Windows, Excel version and Location of files)
And still when i copy the workbook and vba's from one to another there is a "Hardcode" from the other pc..
Is the only way to solve this is using one of the points you described in your post above?
--- In smf_addin@yahoogrou
>
> Unfortunately, this is a common situation when workbooks are shared. It
> occurs because when you save your EXCEL file,MicroSoft decided to save the
> hard-coded location of the add-in in the cell formula, so that EXCEL knows
> the function comes from an external source. Then, when the file is opened,
> EXCEL looks for that external source. If it finds it, it resolves the link
> and removes the hard-coded location -- all is well. However, if it doesn't
> find the external source, EXCEL marks it as an unresolved link, which makes
> the cell non-functional until the link error is resolved.
>
> As you note, a manual change, cell by cell, does fix the problem. If you
> check EXCEL's menus, you find a way to > Edit > Links, which is another way
> to solve the issue for an entire workbook. However, I've found it work
> differently on different versions of EXCEL and was not a reliable way to fix
> link errors.
>
> The quickest and most reliable way I've found to fix the issue is to do a
> "Find and Replace All" (keyboard shortcut Ctrl+H), replacing all hard-coded
> locations:
>
> 'C:\User Name\Application
> Data\Microsoft\
>
> ...with nothing. Once that is done and the file is saved, that person's
> hard-coded add-in location will be saved with the formulas, so that the next
> time they open the file on their computer, the links will be resolved
> automatically.
>
> It's one reason I tried to go with a standard folder for the location of the
> add-in in the installation instructions. If everyone used the same location,
> this would never be an issue.
>
> Unfortunately, even I had to violate that, because Vista wouldn't let me
> update the add-in's XLA file while it was located in a subdirectory of the
> "Program Files" folder. The "Find and Replace" process could be automated --
> I have a macro I manually run to do it as needed when I open files that used
> to use my old location:
>
> Public Sub smfFixLinks(
> ActiveSheet.
> What:="'C:\Program Files\SMF
> Add-In\RCH_Stock_
> Replacement:
> LookAt:=xlPart, _
> SearchOrder:
> MatchCase:=False, _
> SearchFormat:
> ReplaceFormat:
> End Sub
>
>
> On Wed, Aug 25, 2010 at 1:45 PM, Ping Zhu <p_zhu00@...
>
> > This might be a pretty dumb question, but I've got an issue when I tried
> > to copy my working Excel model to my colleagues' computers. I installed
> > RCH_Stock_Market_
> > develop a model by placing the formulas in some cells directly (not in VBA
> > code). For example:
> >
> > In cell A1, I placed "=RCHGetElementNumb
> > got the result as "YUM! BRANDS INC".
> >
> > Unfortunately, when I copy this same Excel file to another computer (with
> > SMF Add-Ins installed), the formula in cell A1 was automatically changed to
> > something like:
> >
> > ='C:\User Name\Application
> > Data\Microsoft\
> > 13862)
> >
> > As a result, this cell no longer returns a valid result. If I manually
> > remove the path, it'll work fine in the new computer. However, this is very
> > tedious as I have many RCHGetElementNumber calls in lots of cells.
> >
> > I suspect I'm not installing the Excel add-in correctly? Is there a way so
> > that I can freely copy my finished models to other computers in the future,
> > without encountering the same problem?
> >
>
Sat Jul 7, 2012 9:08 am (PDT) . Posted by: "Randy Harmelink" rharmelink
If you have the add-in ACTIVE in the same location on each PC, then there
shouldn't be a problem. I would suspect that even though you have the
add-in in the same location, one or the other is NOT the location pointed
to by the add-in manager. For example, if you have the add-in files on one
of the computers twice, but have EXCEL pointed to the other location.
Are the two "hardcode" locations identical when you move files back and
forth?
On Sat, Jul 7, 2012 at 9:02 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> Randy isn't there a way to go around this error?
>
> At this moment i use to vista pc's with everything the same. (Windows,
> Excel version and Location of files)
>
> And still when i copy the workbook and vba's from one to another there is
> a "Hardcode" from the other pc..
>
> Is the only way to solve this is using one of the points you described in
> your post above?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Unfortunately, this is a common situation when workbooks are shared. It
> > occurs because when you save your EXCEL file,MicroSoft decided to save
> the
> > hard-coded location of the add-in in the cell formula, so that EXCEL
> knows
> > the function comes from an external source. Then, when the file is
> opened,
> > EXCEL looks for that external source. If it finds it, it resolves the
> link
> > and removes the hard-coded location -- all is well. However, if it
> doesn't
> > find the external source, EXCEL marks it as an unresolved link, which
> makes
> > the cell non-functional until the link error is resolved.
> >
> > As you note, a manual change, cell by cell, does fix the problem. If you
> > check EXCEL's menus, you find a way to > Edit > Links, which is another
> way
> > to solve the issue for an entire workbook. However, I've found it work
> > differently on different versions of EXCEL and was not a reliable way to
> fix
> > link errors.
> >
> > The quickest and most reliable way I've found to fix the issue is to do a
> > "Find and Replace All" (keyboard shortcut Ctrl+H), replacing all
> hard-coded
> > locations:
> >
> > 'C:\User Name\Application
> > Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!
> >
> > ...with nothing. Once that is done and the file is saved, that person's
> > hard-coded add-in location will be saved with the formulas, so that the
> next
> > time they open the file on their computer, the links will be resolved
> > automatically.
> >
> > It's one reason I tried to go with a standard folder for the location of
> the
> > add-in in the installation instructions. If everyone used the same
> location,
> > this would never be an issue.
> >
> > Unfortunately, even I had to violate that, because Vista wouldn't let me
> > update the add-in's XLA file while it was located in a subdirectory of
> the
> > "Program Files" folder. The "Find and Replace" process could be
> automated --
> > I have a macro I manually run to do it as needed when I open files that
> used
> > to use my old location:
> >
> > Public Sub smfFixLinks()
> > ActiveSheet.Cells.Replace _
> > What:="'C:\Program Files\SMF
> > Add-In\RCH_Stock_Market_Functions.xla'!", _
> > Replacement:="", _
> > LookAt:=xlPart, _
> > SearchOrder:=xlByRows, _
> > MatchCase:=False, _
> > SearchFormat:=False, _
> > ReplaceFormat:=False
> > End Sub
>
shouldn't be a problem. I would suspect that even though you have the
add-in in the same location, one or the other is NOT the location pointed
to by the add-in manager. For example, if you have the add-in files on one
of the computers twice, but have EXCEL pointed to the other location.
Are the two "hardcode" locations identical when you move files back and
forth?
On Sat, Jul 7, 2012 at 9:02 AM, antonvanas1989 <antonvanas1989@
> Randy isn't there a way to go around this error?
>
> At this moment i use to vista pc's with everything the same. (Windows,
> Excel version and Location of files)
>
> And still when i copy the workbook and vba's from one to another there is
> a "Hardcode" from the other pc..
>
> Is the only way to solve this is using one of the points you described in
> your post above?
>
> --- In smf_addin@yahoogrou
> >
> > Unfortunately, this is a common situation when workbooks are shared. It
> > occurs because when you save your EXCEL file,MicroSoft decided to save
> the
> > hard-coded location of the add-in in the cell formula, so that EXCEL
> knows
> > the function comes from an external source. Then, when the file is
> opened,
> > EXCEL looks for that external source. If it finds it, it resolves the
> link
> > and removes the hard-coded location -- all is well. However, if it
> doesn't
> > find the external source, EXCEL marks it as an unresolved link, which
> makes
> > the cell non-functional until the link error is resolved.
> >
> > As you note, a manual change, cell by cell, does fix the problem. If you
> > check EXCEL's menus, you find a way to > Edit > Links, which is another
> way
> > to solve the issue for an entire workbook. However, I've found it work
> > differently on different versions of EXCEL and was not a reliable way to
> fix
> > link errors.
> >
> > The quickest and most reliable way I've found to fix the issue is to do a
> > "Find and Replace All" (keyboard shortcut Ctrl+H), replacing all
> hard-coded
> > locations:
> >
> > 'C:\User Name\Application
> > Data\Microsoft\
> >
> > ...with nothing. Once that is done and the file is saved, that person's
> > hard-coded add-in location will be saved with the formulas, so that the
> next
> > time they open the file on their computer, the links will be resolved
> > automatically.
> >
> > It's one reason I tried to go with a standard folder for the location of
> the
> > add-in in the installation instructions. If everyone used the same
> location,
> > this would never be an issue.
> >
> > Unfortunately, even I had to violate that, because Vista wouldn't let me
> > update the add-in's XLA file while it was located in a subdirectory of
> the
> > "Program Files" folder. The "Find and Replace" process could be
> automated --
> > I have a macro I manually run to do it as needed when I open files that
> used
> > to use my old location:
> >
> > Public Sub smfFixLinks(
> > ActiveSheet.
> > What:="'C:\Program Files\SMF
> > Add-In\RCH_Stock_
> > Replacement:
> > LookAt:=xlPart, _
> > SearchOrder:
> > MatchCase:=False, _
> > SearchFormat:
> > ReplaceFormat:
> > End Sub
>
Sat Jul 7, 2012 9:43 am (PDT) . Posted by: "antonvanas1989" antonvanas1989
I had not try it before, but i just tried. Exactly the same..
But i use =C:\Users\ >USER< \AppData\Roaming\Microsoft\AddIns\
this location, i think this cauze the trouble becauze the "User" have not the same name..
I thought this location was appointed by you? (when i start using the addin back couple years)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> If you have the add-in ACTIVE in the same location on each PC, then there
> shouldn't be a problem. I would suspect that even though you have the
> add-in in the same location, one or the other is NOT the location pointed
> to by the add-in manager. For example, if you have the add-in files on one
> of the computers twice, but have EXCEL pointed to the other location.
>
> Are the two "hardcode" locations identical when you move files back and
> forth?
>
> On Sat, Jul 7, 2012 at 9:02 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > Randy isn't there a way to go around this error?
> >
> > At this moment i use to vista pc's with everything the same. (Windows,
> > Excel version and Location of files)
> >
> > And still when i copy the workbook and vba's from one to another there is
> > a "Hardcode" from the other pc..
> >
> > Is the only way to solve this is using one of the points you described in
> > your post above?
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Unfortunately, this is a common situation when workbooks are shared. It
> > > occurs because when you save your EXCEL file,MicroSoft decided to save
> > the
> > > hard-coded location of the add-in in the cell formula, so that EXCEL
> > knows
> > > the function comes from an external source. Then, when the file is
> > opened,
> > > EXCEL looks for that external source. If it finds it, it resolves the
> > link
> > > and removes the hard-coded location -- all is well. However, if it
> > doesn't
> > > find the external source, EXCEL marks it as an unresolved link, which
> > makes
> > > the cell non-functional until the link error is resolved.
> > >
> > > As you note, a manual change, cell by cell, does fix the problem. If you
> > > check EXCEL's menus, you find a way to > Edit > Links, which is another
> > way
> > > to solve the issue for an entire workbook. However, I've found it work
> > > differently on different versions of EXCEL and was not a reliable way to
> > fix
> > > link errors.
> > >
> > > The quickest and most reliable way I've found to fix the issue is to do a
> > > "Find and Replace All" (keyboard shortcut Ctrl+H), replacing all
> > hard-coded
> > > locations:
> > >
> > > 'C:\User Name\Application
> > > Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!
> > >
> > > ...with nothing. Once that is done and the file is saved, that person's
> > > hard-coded add-in location will be saved with the formulas, so that the
> > next
> > > time they open the file on their computer, the links will be resolved
> > > automatically.
> > >
> > > It's one reason I tried to go with a standard folder for the location of
> > the
> > > add-in in the installation instructions. If everyone used the same
> > location,
> > > this would never be an issue.
> > >
> > > Unfortunately, even I had to violate that, because Vista wouldn't let me
> > > update the add-in's XLA file while it was located in a subdirectory of
> > the
> > > "Program Files" folder. The "Find and Replace" process could be
> > automated --
> > > I have a macro I manually run to do it as needed when I open files that
> > used
> > > to use my old location:
> > >
> > > Public Sub smfFixLinks()
> > > ActiveSheet.Cells.Replace _
> > > What:="'C:\Program Files\SMF
> > > Add-In\RCH_Stock_Market_Functions.xla'!", _
> > > Replacement:="", _
> > > LookAt:=xlPart, _
> > > SearchOrder:=xlByRows, _
> > > MatchCase:=False, _
> > > SearchFormat:=False, _
> > > ReplaceFormat:=False
> > > End Sub
> >
>
But i use =C:\Users\ >USER< \AppData\Roaming\
this location, i think this cauze the trouble becauze the "User" have not the same name..
I thought this location was appointed by you? (when i start using the addin back couple years)
--- In smf_addin@yahoogrou
>
> If you have the add-in ACTIVE in the same location on each PC, then there
> shouldn't be a problem. I would suspect that even though you have the
> add-in in the same location, one or the other is NOT the location pointed
> to by the add-in manager. For example, if you have the add-in files on one
> of the computers twice, but have EXCEL pointed to the other location.
>
> Are the two "hardcode" locations identical when you move files back and
> forth?
>
> On Sat, Jul 7, 2012 at 9:02 AM, antonvanas1989 <antonvanas1989@
>
> > Randy isn't there a way to go around this error?
> >
> > At this moment i use to vista pc's with everything the same. (Windows,
> > Excel version and Location of files)
> >
> > And still when i copy the workbook and vba's from one to another there is
> > a "Hardcode" from the other pc..
> >
> > Is the only way to solve this is using one of the points you described in
> > your post above?
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Unfortunately, this is a common situation when workbooks are shared. It
> > > occurs because when you save your EXCEL file,MicroSoft decided to save
> > the
> > > hard-coded location of the add-in in the cell formula, so that EXCEL
> > knows
> > > the function comes from an external source. Then, when the file is
> > opened,
> > > EXCEL looks for that external source. If it finds it, it resolves the
> > link
> > > and removes the hard-coded location -- all is well. However, if it
> > doesn't
> > > find the external source, EXCEL marks it as an unresolved link, which
> > makes
> > > the cell non-functional until the link error is resolved.
> > >
> > > As you note, a manual change, cell by cell, does fix the problem. If you
> > > check EXCEL's menus, you find a way to > Edit > Links, which is another
> > way
> > > to solve the issue for an entire workbook. However, I've found it work
> > > differently on different versions of EXCEL and was not a reliable way to
> > fix
> > > link errors.
> > >
> > > The quickest and most reliable way I've found to fix the issue is to do a
> > > "Find and Replace All" (keyboard shortcut Ctrl+H), replacing all
> > hard-coded
> > > locations:
> > >
> > > 'C:\User Name\Application
> > > Data\Microsoft\
> > >
> > > ...with nothing. Once that is done and the file is saved, that person's
> > > hard-coded add-in location will be saved with the formulas, so that the
> > next
> > > time they open the file on their computer, the links will be resolved
> > > automatically.
> > >
> > > It's one reason I tried to go with a standard folder for the location of
> > the
> > > add-in in the installation instructions. If everyone used the same
> > location,
> > > this would never be an issue.
> > >
> > > Unfortunately, even I had to violate that, because Vista wouldn't let me
> > > update the add-in's XLA file while it was located in a subdirectory of
> > the
> > > "Program Files" folder. The "Find and Replace" process could be
> > automated --
> > > I have a macro I manually run to do it as needed when I open files that
> > used
> > > to use my old location:
> > >
> > > Public Sub smfFixLinks(
> > > ActiveSheet.
> > > What:="'C:\Program Files\SMF
> > > Add-In\RCH_Stock_
> > > Replacement:
> > > LookAt:=xlPart, _
> > > SearchOrder:
> > > MatchCase:=False, _
> > > SearchFormat:
> > > ReplaceFormat:
> > > End Sub
> >
>
Sat Jul 7, 2012 11:39 am (PDT) . Posted by: "Randy Harmelink" rharmelink
That would typically be the Microsoft suggested location to use for
add-ins. But, since the user name can vary, it would never work smoothly
for workbooks that need to be shared between computers.
The location recommended in the add-in documentation has been the same for
at least 5 years. I had to change my location when I got my first Vista
computer in 2008.
On Sat, Jul 7, 2012 at 9:43 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> I had not try it before, but i just tried. Exactly the same..
>
> But i use =C:\Users\ >USER< \AppData\Roaming\Microsoft\AddIns\
>
> this location, i think this cauze the trouble becauze the "User" have not
> the same name..
>
> I thought this location was appointed by you? (when i start using the
> addin back couple years)
>
add-ins. But, since the user name can vary, it would never work smoothly
for workbooks that need to be shared between computers.
The location recommended in the add-in documentation has been the same for
at least 5 years. I had to change my location when I got my first Vista
computer in 2008.
On Sat, Jul 7, 2012 at 9:43 AM, antonvanas1989 <antonvanas1989@
> I had not try it before, but i just tried. Exactly the same..
>
> But i use =C:\Users\ >USER< \AppData\Roaming\
>
> this location, i think this cauze the trouble becauze the "User" have not
> the same name..
>
> I thought this location was appointed by you? (when i start using the
> addin back couple years)
>
Sat Jul 7, 2012 7:35 pm (PDT) . Posted by: "Ronald Ricker MD" rricker@pacbell.net
I have been using this Add-in with a Trend Exhaustion spreadsheet. As of a few
days ago, some symbols which had been working are no longer registering (e.g.
^bktla, ^bktem, ^djinet, ^djuswc, ^djusoq, ^djuspr, ^djgsp, ^djusbk, ^djusbt,
^dji, ^bktcn).
Randy replied saying: "It appears Dow Jones has restricted access to their
"proprietary" data on Yahoo. You'd need to find a different source for the
quotes, providing Dow Jones hasn't tightened them up as well. Or retrieve the
quotes from the displayed historical quotes on Yahoo."
However that doesn't explain why other Dow Jones specific indexes(e.g.
^djusfn) continue to work on the spreadsheet.
Any ideas?
Randy suggested I write to the group.
Thanks again.
Ron
Sat Jul 7, 2012 7:46 pm (PDT) . Posted by: "Randy H" rharmelink
It started with ^DJI about a week ago, and has since spread.
^DJUSFN doesn't work for me right now. And if you look at the historical
quotes page:
http://finance.yahoo.com/q/hp?s= ^DJUSFN
...you'll notice there is no "Download to Spreadsheet" link on the
bottom of the page like there is here:
http://finance.yahoo.com/q/hp?s=MMM
That lack of a "Download to Spreadsheet" link indicates that Yahoo is no
longer providing a CSV file of the historical quotes.
For a definitive answer, you'll need to ask Yahoo why the "Download to
Spreadsheet" links no longer exist.
Note that the CSV data for current quotes went away last November:
http://finance.groups.yahoo.com/group/smf_addin/message/16803
This was Yahoo's response at the time:
http://help.yahoo.com/kb/index?page=content&y=PROD_FIN&locale=en_US&id=S\
LN2349
On Sat, Jul 7, 2012 at 7:25 PM, Ronald Ricker MD <rricker@pacbell.net
<mailto:rricker@pacbell.net > > wrote:
I have been using this Add-in with a Trend Exhaustion spreadsheet.
As of a few days ago, some symbols which had been working are no longer
registering (e.g. ^bktla, ^bktem, ^djinet, ^djuswc, ^djusoq, ^djuspr,
^djgsp, ^djusbk, ^djusbt, ^dji, ^bktcn). Randy replied saying: "It
appears Dow Jones has restricted access to their "proprietary" data on
Yahoo. You'd need to find a different source for the quotes, providing
Dow Jones hasn't tightened them up as well. Or retrieve the quotes from
the displayed historical quotes on Yahoo."
However that doesn't explain why other Dow Jones specific indexes(e.g.
^djusfn) continue to work on the spreadsheet. Any ideas?
^DJUSFN doesn't work for me right now. And if you look at the historical
quotes page:
http://finance.
...you'll notice there is no "Download to Spreadsheet" link on the
bottom of the page like there is here:
http://finance.
That lack of a "Download to Spreadsheet" link indicates that Yahoo is no
longer providing a CSV file of the historical quotes.
For a definitive answer, you'll need to ask Yahoo why the "Download to
Spreadsheet" links no longer exist.
Note that the CSV data for current quotes went away last November:
http://finance.
This was Yahoo's response at the time:
http://help.
LN2349
On Sat, Jul 7, 2012 at 7:25 PM, Ronald Ricker MD <rricker@pacbell.
<mailto:rricker@pacbell.
I have been using this Add-in with a Trend Exhaustion spreadsheet.
As of a few days ago, some symbols which had been working are no longer
registering (e.g. ^bktla, ^bktem, ^djinet, ^djuswc, ^djusoq, ^djuspr,
^djgsp, ^djusbk, ^djusbt, ^dji, ^bktcn). Randy replied saying: "It
appears Dow Jones has restricted access to their "proprietary" data on
Yahoo. You'd need to find a different source for the quotes, providing
Dow Jones hasn't tightened them up as well. Or retrieve the quotes from
the displayed historical quotes on Yahoo."
However that doesn't explain why other Dow Jones specific indexes(e.g.
^djusfn) continue to work on the spreadsheet. Any ideas?
Sat Jul 7, 2012 8:49 pm (PDT) . Posted by: "Ronald Ricker MD" rricker@pacbell.net
Randy
thanks. Any idea where to turn to keep using DeMark?
Ron
____________
From: Randy H <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sat, July 7, 2012 7:47:00 PM
Subject: [smf_addin] Re: some symbols no longer working
It started with ^DJI about a week ago, and has since spread.
^DJUSFN doesn't work for me right now. And if you look at the historical quotes
page:
http://finance.
...you'll notice there is no "Download to Spreadsheet" link on the bottom of the
page like there is here:
http://finance.
That lack of a "Download to Spreadsheet" link indicates that Yahoo is no longer
providing a CSV file of the historical quotes.
For a definitive answer, you'll need to ask Yahoo why the "Download to
Spreadsheet" links no longer exist.
Note that the CSV data for current quotes went away last November:
http://finance.
This was Yahoo's response at the time:
http://help.
On Sat, Jul 7, 2012 at 7:25 PM, Ronald Ricker MD <rricker@pacbell.
>
>I have been using this Add-in with a Trend Exhaustion spreadsheet. As of a few
>days ago, some symbols which had been working are no longer registering (e.g.
>^bktla, ^bktem, ^djinet, ^djuswc, ^djusoq, ^djuspr, ^djgsp, ^djusbk, ^djusbt,
>^dji, ^bktcn).
>
>Randy replied saying: "It appears Dow Jones has restricted access to their
>"proprietary" data on Yahoo. You'd need to find a different source for the
>quotes, providing Dow Jones hasn't tightened them up as well. Or retrieve the
>quotes from the displayed historical quotes on Yahoo."
>
>However that doesn't explain why other Dow Jones specific indexes(e.g.
>^djusfn) continue to work on the spreadsheet.
>
>Any ideas?
>
Sat Jul 7, 2012 9:07 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
I don't know what you need, but some data is still there -- just not as a
convenient CSV file.
And the older data never changes on the indexes, right? So you don't
necessarily need to grab the entire history of quotes every time.
On Sat, Jul 7, 2012 at 8:49 PM, Ronald Ricker MD <rricker@pacbell.net >wrote:
> thanks. Any idea where to turn to keep using DeMark?
>
convenient CSV file.
And the older data never changes on the indexes, right? So you don't
necessarily need to grab the entire history of quotes every time.
On Sat, Jul 7, 2012 at 8:49 PM, Ronald Ricker MD <rricker@pacbell.
> thanks. Any idea where to turn to keep using DeMark?
>
Tidak ada komentar:
Posting Komentar