7 Messages
Digest #4126
Messages
Mon Aug 21, 2017 2:39 am (PDT) . Posted by:
paulo_million
Thanks for your work Randy.
OX2 does not work for SPX.
B doesn't either.
Could you help me?
OX2 does not work for SPX.
B doesn't either.
Could you help me?
Mon Aug 21, 2017 6:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, it appears neither OX2 or Barchart have similar behaviors
for indexes like $SPX, so the normal processing won't work...
.
.
.
*Later *-- I was able to change the add-in so the following will work:
=smfGetOptionQuotes("$SPX 8/25 2017 $2400 Put","5",,"B")
The problem was that I had the add-in looking for a strike price of
"$2400.00" when searching the JSON code from barchart.com, but it needed to
be looking for a strike price of "2,400.00". I never use any equities with
strike prices of $1000 or more, so the problem never showed up for me.
So it should work for the next (beta?) release of the add-in.
On Mon, Aug 21, 2017 at 2:39 AM, milliongoal@
...
wrote:
>
> OX2 does not work for SPX.
> B doesn't either.
>
> Could you help me?
>
for indexes like $SPX, so the normal processing won't work...
.
.
.
*Later *-- I was able to change the add-in so the following will work:
=smfGetOptionQuotes
The problem was that I had the add-in looking for a strike price of
"$2400.
be looking for a strike price of "2,400.
strike prices of $1000 or more, so the problem never showed up for me.
So it should work for the next (beta?) release of the add-in.
On Mon, Aug 21, 2017 at 2:39 AM, milliongoal@
...
wrote:
>
> OX2 does not work for SPX.
> B doesn't either.
>
> Could you help me?
>
Mon Aug 21, 2017 11:44 am (PDT) . Posted by:
mjblauer
Randy, My get current web page was set correctly in IE
To solve the issue:
First I set IE as my default browser instead of Chrome.
Second I saved the Excel file under a new name using the SMFgetyahoohistory
Restarted the new Excel file
All fields loaded and working fine.
Thanks as always !!!!
To solve the issue:
First I set IE as my default browser instead of Chrome.
Second I saved the Excel file under a new name using the SMFgetyahoohistory
Restarted the new Excel file
All fields loaded and working fine.
Thanks as always !!!!
Mon Aug 21, 2017 11:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your browser choice is irrelevant. That is a completely separate process.
The link is that both IE and EXCEL are Microsoft products, and they both
use the same engine to access the Internet. The add-in uses the same
Microsoft software libraries to grab the source code of web pages. So IE
settings are relevant to EXCEL and the add-in.
On Mon, Aug 21, 2017 at 11:44 AM, mblauer@
...
wrote:
>
> My get current web page was set correctly in IE
> To solve the issue:
> First I set IE as my default browser instead of Chrome.
> Second I saved the Excel file under a new name using the SMFgetyahoohistory
> Restarted the new Excel file
> All fields loaded and working fine.
> Thanks as always !!!!
>
The link is that both IE and EXCEL are Microsoft products, and they both
use the same engine to access the Internet. The add-in uses the same
Microsoft software libraries to grab the source code of web pages. So IE
settings are relevant to EXCEL and the add-in.
On Mon, Aug 21, 2017 at 11:44 AM, mblauer@
...
wrote:
>
> My get current web page was set correctly in IE
> To solve the issue:
> First I set IE as my default browser instead of Chrome.
> Second I saved the Excel file under a new name using the SMFgetyahoohistory
> Restarted the new Excel file
> All fields loaded and working fine.
> Thanks as always !!!!
>
Mon Aug 21, 2017 1:59 pm (PDT) . Posted by:
ridgebacksexcel
Randy,
Microsoft just turned on a new feature for Excel 365 called Autosave. It automatically saves spreadsheets including those with your add-in. Previously I had to "Save As" with files with your add-in to my OneDrive's Spreadsheet folder in order to not break the add-in link to the SMF Add-in file. I could then save normally as long as the file remained open and the link would remain. Each time I re-opened the file I had to "Save As" before closing to keep the link open.
With the new Excel feature that option no longer seems available. There is no Save As with Autosave enabled. You could Save a Copy with a different name but that starts a new set of problems. With Autosave off, you can "Save As" again but you now get an error message that says "You cannot save this workbook with the same name as another open workbook or add-in. Choose a different name , or close the other workbook or add-in before saving."
After closing the file, when you reopen the workbook with your add-in, Excel tries to open the add-in from OneDrive and is unable to. I keep the add-in under C:/Program Files/Smf Add-in. This is the only location I can get it to work from. The add-in must open from my hard drive and not the cloud. So when the workbook opens the link is broken after it is unable to open from with in OneDrive. The fix is to go to Edit Links, Change Source and select again C:/Program Files/ Smf Add-in then the add-in file. That's a real pain to do every time I open the workbook now.
Have you heard of this problem? Is there another solution to keep the link from breaking?
Microsoft just turned on a new feature for Excel 365 called Autosave. It automatically saves spreadsheets including those with your add-in. Previously I had to "Save As" with files with your add-in to my OneDrive'
With the new Excel feature that option no longer seems available. There is no Save As with Autosave enabled. You could Save a Copy with a different name but that starts a new set of problems. With Autosave off, you can "Save As" again but you now get an error message that says "You cannot save this workbook with the same name as another open workbook or add-in. Choose a different name , or close the other workbook or add-in before saving."
After closing the file, when you reopen the workbook with your add-in, Excel tries to open the add-in from OneDrive and is unable to. I keep the add-in under C:/Program Files/Smf Add-in. This is the only location I can get it to work from. The add-in must open from my hard drive and not the cloud. So when the workbook opens the link is broken after it is unable to open from with in OneDrive. The fix is to go to Edit Links, Change Source and select again C:/Program Files/ Smf Add-in then the add-in file. That's a real pain to do every time I open the workbook now.
Have you heard of this problem? Is there another solution to keep the link from breaking?
Mon Aug 21, 2017 5:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What version are you running? I'm using Microsoft Office 365, Version 1706
(Build 8229.2103), and I've not had any of the problems you're running
into. I don't use Dropbox, but I do use Google Drive for my workbooks, but
not the add-in.
Your comments about "not breaking the links" make no sense to me. I don't
need to do anything special.
I do need to run the smfFixLinks macro from time to time, but almost always
when someone else has sent me a workbook with that uses the add-in and they
have the add-in in a different location than I do.
BTW, EXCEL has *never* let me do a "Save As" to a currently existing file
that is open and being used by some other application. At least as far back
as I can recall -- EXCEL 2003 or even earlier. "Save As" is used to save
the workbook under another name. If you want to save it under the same
name, you'd just use "Save".
You have me very confused...
On Mon, Aug 21, 2017 at 1:59 PM, tmallen2@
...
wrote:
> Microsoft just turned on a new feature for Excel 365 called Autosave. It
> automatically saves spreadsheets including those with your
> add-in. Previously I had to "Save As" with files with your add-in to my
> OneDrive's Spreadsheet folder in order to not break the add-in link to the
> SMF Add-in file. I could then save normally as long as the file remained
> open and the link would remain. Each time I re-opened the file I had to
> "Save As" before closing to keep the link open.
>
> With the new Excel feature that option no longer seems available. There is
> no Save As with Autosave enabled. You could Save a Copy with a different
> name but that starts a new set of problems. With Autosave off, you can
> "Save As" again but you now get an error message that says "You cannot save
> this workbook with the same name as another open workbook or add-in. Choose
> a different name , or close the other workbook or add-in before saving."
>
> After closing the file, when you reopen the workbook with your add-in,
> Excel tries to open the add-in from OneDrive and is unable to. I keep the
> add-in under C:/Program Files/Smf Add-in. This is the only location I can
> get it to work from. The add-in must open from my hard drive and not the
> cloud. So when the workbook opens the link is broken after it is unable to
> open from with in OneDrive. The fix is to go to Edit Links, Change Source
> and select again C:/Program Files/ Smf Add-in then the add-in file. That's
> a real pain to do every time I open the workbook now.
>
> Have you heard of this problem? Is there another solution to keep the link
> from breaking?
>
(Build 8229.2103), and I've not had any of the problems you're running
into. I don't use Dropbox, but I do use Google Drive for my workbooks, but
not the add-in.
Your comments about "not breaking the links" make no sense to me. I don't
need to do anything special.
I do need to run the smfFixLinks macro from time to time, but almost always
when someone else has sent me a workbook with that uses the add-in and they
have the add-in in a different location than I do.
BTW, EXCEL has *never* let me do a "Save As" to a currently existing file
that is open and being used by some other application. At least as far back
as I can recall -- EXCEL 2003 or even earlier. "Save As" is used to save
the workbook under another name. If you want to save it under the same
name, you'd just use "Save"
You have me very confused...
On Mon, Aug 21, 2017 at 1:59 PM, tmallen2@
...
wrote:
> Microsoft just turned on a new feature for Excel 365 called Autosave. It
> automatically saves spreadsheets including those with your
> add-in. Previously I had to "Save As" with files with your add-in to my
> OneDrive'
> SMF Add-in file. I could then save normally as long as the file remained
> open and the link would remain. Each time I re-opened the file I had to
> "Save As" before closing to keep the link open.
>
> With the new Excel feature that option no longer seems available. There is
> no Save As with Autosave enabled. You could Save a Copy with a different
> name but that starts a new set of problems. With Autosave off, you can
> "Save As" again but you now get an error message that says "You cannot save
> this workbook with the same name as another open workbook or add-in. Choose
> a different name , or close the other workbook or add-in before saving."
>
> After closing the file, when you reopen the workbook with your add-in,
> Excel tries to open the add-in from OneDrive and is unable to. I keep the
> add-in under C:/Program Files/Smf Add-in. This is the only location I can
> get it to work from. The add-in must open from my hard drive and not the
> cloud. So when the workbook opens the link is broken after it is unable to
> open from with in OneDrive. The fix is to go to Edit Links, Change Source
> and select again C:/Program Files/ Smf Add-in then the add-in file. That's
> a real pain to do every time I open the workbook now.
>
> Have you heard of this problem? Is there another solution to keep the link
> from breaking?
>
Mon Aug 21, 2017 7:11 pm (PDT) . Posted by:
ridgebacksexcel
I am running build 8326.2073 It just started today so it must be brand new.
I normally keep the add in folder on my hard drive in the program files folder. I have never been able to get it to ever run from anywhere in the OneDrive folder.
The default location Excel looks for the add in file now is:
https://d.docs.live.net/program https://d.docs.live.net/program files/smf add-in/RCH_Stock_Market_functions.xla
I cannot change the location to where I want it: C:/Program Files/smf add-in/RCH_Stock_Market_functions.xla
Every time I open Excel now, I have to go to Data, Edit links, Change Source and point back to:
C:/Program Files/smf add-in/RCH_Stock_Market_functions.xla then it will run. It won't run in any OneDrive folder and never has. Before I could always select Save As and point back to the same folder in OneDrive my workbook resides and it would remember the Add-in location on my hard drive. Now I can't do that and must manually re-establish the link. There was discussion about this "save as" work around a few years back on this group as I remember.
How exactly do you have yours set up. Location of the Workbook and location of the Add-in?
I normally keep the add in folder on my hard drive in the program files folder. I have never been able to get it to ever run from anywhere in the OneDrive folder.
The default location Excel looks for the add in file now is:
https://d.docs.live.net/program https://d.docs.live.net/program files/smf add-in/RCH_Stock_
I cannot change the location to where I want it: C:/Program Files/smf add-in/RCH_Stock_
Every time I open Excel now, I have to go to Data, Edit links, Change Source and point back to:
C:/Program Files/smf add-in/RCH_Stock_
How exactly do you have yours set up. Location of the Workbook and location of the Add-in?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar