15 Messages
Digest #4321
Messages
Fri Mar 30, 2018 1:45 am (PDT) . Posted by:
ethanbond911
Hello Guys and Gals:
I have an excel spread sheet that predicts trend for DJI, DIA and /YM based on math. I have been trading with the help of excel sheet for sometime with better then average entries and exits.
I am not the creator of this worksheet. I need to modify this excel sheet by using the same format that's it currently employs.
What am I talking about? I need the excel sheet's rows and columns to be extended all the way to the end of the last column and row of excel sheet.
I also would like someone to plot line charts (yes I will tell you which data to be plotted)
I need someone who is a master of excel not a mediocre user. What's in it for you if you do decide to help? for that please feel free to email me since there is good amount of money involved. So I hope one of you fine man or woman can help me and make my life easier.
Ethan
I have an excel spread sheet that predicts trend for DJI, DIA and /YM based on math. I have been trading with the help of excel sheet for sometime with better then average entries and exits.
I am not the creator of this worksheet. I need to modify this excel sheet by using the same format that's it currently employs.
What am I talking about? I need the excel sheet's rows and columns to be extended all the way to the end of the last column and row of excel sheet.
I also would like someone to plot line charts (yes I will tell you which data to be plotted)
I need someone who is a master of excel not a mediocre user. What's in it for you if you do decide to help? for that please feel free to email me since there is good amount of money involved. So I hope one of you fine man or woman can help me and make my life easier.
Ethan
Wed Apr 4, 2018 4:01 pm (PDT) . Posted by:
john_hoel
In the last several weeks, every time I update one of my spreadsheets, I get the following pop up notification from Excel:
Code execution has been interrupted
and action choices are "Continue";, "End", "Debug", and "Help"
When I select "Debug", the following line in RCHGetURLData1 is highlighted in yellow:
Do While bASync
When I select "Continue"; or run in Developer mode, execution resumes, until the same interrupt happens again. It happens many times as my worksheet does a number of fetches. When all updating is completed, all fetches are successful. There is no actual error.
I am using SMF version 2.1.2017.11.30
Can you think of any reason why this happens? Is there anything I can do to prevent this from happening?
Code execution has been interrupted
and action choices are "Continue"
When I select "Debug"
Do While bASync
When I select "Continue"
I am using SMF version 2.1.2017.11.
Can you think of any reason why this happens? Is there anything I can do to prevent this from happening?
Wed Apr 4, 2018 6:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The only reason I could think of that happening is that somehow the code,
or that variable, got corrupted somehow. I can't think of why else it would
be happening only to you?
You can try updating to the current version of the add-in?
On Wed, Apr 4, 2018 at 4:00 PM, johnhoel1248@
...
wrote:
>
> In the last several weeks, every time I update one of my spreadsheets, I
> get the following pop up notification from Excel:
>
> Code execution has been interrupted
>
> and action choices are "Continue";, "End", "Debug", and "Help"
>
> When I select "Debug", the following line in RCHGetURLData1 is highlighted
> in yellow:
>
> Do While bASync
>
> When I select "Continue"; or run in Developer mode, execution resumes,
> until the same interrupt happens again. It happens many times as my
> worksheet does a number of fetches. When all updating is completed, all
> fetches are successful. There is no actual error.
>
> I am using SMF version 2.1.2017.11.30
>
> Can you think of any reason why this happens? Is there anything I can do
> to prevent this from happening?
>
>
or that variable, got corrupted somehow. I can't think of why else it would
be happening only to you?
You can try updating to the current version of the add-in?
On Wed, Apr 4, 2018 at 4:00 PM, johnhoel1248@
...
wrote:
>
> In the last several weeks, every time I update one of my spreadsheets, I
> get the following pop up notification from Excel:
>
> Code execution has been interrupted
>
> and action choices are "Continue"
>
> When I select "Debug"
> in yellow:
>
> Do While bASync
>
> When I select "Continue"
> until the same interrupt happens again. It happens many times as my
> worksheet does a number of fetches. When all updating is completed, all
> fetches are successful. There is no actual error.
>
> I am using SMF version 2.1.2017.11.
>
> Can you think of any reason why this happens? Is there anything I can do
> to prevent this from happening?
>
>
Tue Apr 10, 2018 6:56 am (PDT) . Posted by:
john_hoel
I have installed the latest release. But I don't think that will change anything. I think Excel itself is somehow causing this. No data, just an impression.
Sat Apr 7, 2018 10:41 am (PDT) . Posted by:
brad.reel
Howdy everyone. Has anyone encountered and figured out how to get logged into IBD and have the cookie persist using Excel 365?
For context, in Excel 365, there is a new Web Tool for getting web page data.
It appears that tool will not allow you take certain actions or that it loads pages in such a way that you are limited in what you can do. I cannot figure out anyway to be able to login using this new Web Tool.
The legacy tool is still available and it works. I can login (I can explain process I use if anyone gets stuck). However, the problem is that the legacy tool does not persist the cookie. As soon as I close Excel, I lose the cookie and have to repeat this process each time.
If anyone has figured out how to handle this, please let me know. I'd really appreciate it.
Thanks!
BR
For context, in Excel 365, there is a new Web Tool for getting web page data.
It appears that tool will not allow you take certain actions or that it loads pages in such a way that you are limited in what you can do. I cannot figure out anyway to be able to login using this new Web Tool.
The legacy tool is still available and it works. I can login (I can explain process I use if anyone gets stuck). However, the problem is that the legacy tool does not persist the cookie. As soon as I close Excel, I lose the cookie and have to repeat this process each time.
If anyone has figured out how to handle this, please let me know. I'd really appreciate it.
Thanks!
BR
Sat Apr 7, 2018 10:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't really want to fool around with it at this time, since my cookie
seems to be fine and I don't want to lose it. :(
However, if the cookie doesn't persist, the best solution might be to
create a VBA macro that does the login for you. It would be easier to run a
macro than to manually do the login each time. If I get to the point where
the cookie becomes an issue, that's probably what I'll try.
When I've considered something like this in the past, I thought about
making it a subroutine that would get passed the username and password so
that it could be a generally available routine. Then, anyone could use it,
but an individual macro would still be needed to call it, passing the
individual's username and password. The macro or subroutine could also have
a MsgBox pop up indicating whether the login was successful or not. Another
alternative would be to have a macro do it, but get the username and
password from EXCEL defined names (e.g. "IBD_username" and "IBD_password"),
using MsgBox to flag an error to indicate if the defined names didn't exist
in EXCEL.
On Sat, Apr 7, 2018 at 10:31 AM, brad.reel@
...
wrote:
> Howdy everyone. Has anyone encountered and figured out how to get logged
> into IBD and have the cookie persist using Excel 365?
>
> For context, in Excel 365, there is a new Web Tool for getting web page
> data.
>
>
> - It appears that tool will not allow you take certain actions or that
> it loads pages in such a way that you are limited in what you can do.
> - I cannot figure out anyway to be able to login using this new Web
> Tool.
>
> The legacy tool is still available and it works. I can login (I can
> explain process I use if anyone gets stuck). However, the problem is that
> the legacy tool does not persist the cookie. As soon as I close Excel, I
> lose the cookie and have to repeat this process each time.
>
> If anyone has figured out how to handle this, please let me know. I'd
> really appreciate it.
>
>
>
seems to be fine and I don't want to lose it. :(
However, if the cookie doesn't persist, the best solution might be to
create a VBA macro that does the login for you. It would be easier to run a
macro than to manually do the login each time. If I get to the point where
the cookie becomes an issue, that's probably what I'll try.
When I've considered something like this in the past, I thought about
making it a subroutine that would get passed the username and password so
that it could be a generally available routine. Then, anyone could use it,
but an individual macro would still be needed to call it, passing the
individual&#
a MsgBox pop up indicating whether the login was successful or not. Another
alternative would be to have a macro do it, but get the username and
password from EXCEL defined names (e.g. "IBD_username&
using MsgBox to flag an error to indicate if the defined names didn't exist
in EXCEL.
On Sat, Apr 7, 2018 at 10:31 AM, brad.reel@
...
wrote:
> Howdy everyone. Has anyone encountered and figured out how to get logged
> into IBD and have the cookie persist using Excel 365?
>
> For context, in Excel 365, there is a new Web Tool for getting web page
> data.
>
>
> - It appears that tool will not allow you take certain actions or that
> it loads pages in such a way that you are limited in what you can do.
> - I cannot figure out anyway to be able to login using this new Web
> Tool.
>
> The legacy tool is still available and it works. I can login (I can
> explain process I use if anyone gets stuck). However, the problem is that
> the legacy tool does not persist the cookie. As soon as I close Excel, I
> lose the cookie and have to repeat this process each time.
>
> If anyone has figured out how to handle this, please let me know. I'd
> really appreciate it.
>
>
>
Sun Apr 8, 2018 12:49 am (PDT) . Posted by:
lawrence.leesh
Hi Randy
Is your SMFGetTagContent addin able to get from this url https://www.gurufocus.com/stock/AAPL https://www.gurufocus.com/stock/AAPL
the following?
Apple Inc is designs, manufactures and markets mobile communication and media devices and personal computers, and sells a variety of related software, services, accessories, networking solutions and third-party digital content and applications.
Apple designs consumer electronic devices, including smartphones (iPhone), tablets (iPad), PCs (Mac), smartwatches (Watch), and TV boxes (Apple TV), as well as a variety of services such as Apple Music, iCloud, and Apple Pay. Apple's products run internally developed software, and we believe this integration of hardware, software, and services often allows the firm to maintain premium pricing for its devices. Apple's products are distributed online as well as through company-owned stores and third-party retailers.
thanks
Is your SMFGetTagContent addin able to get from this url https://www.gurufocus.com/stock/AAPL https://www.gurufocus.com/stock/AAPL
the following?
Apple Inc is designs, manufactures and markets mobile communication and media devices and personal computers, and sells a variety of related software, services, accessories, networking solutions and third-party digital content and applications.
Apple designs consumer electronic devices, including smartphones (iPhone), tablets (iPad), PCs (Mac), smartwatches (Watch), and TV boxes (Apple TV), as well as a variety of services such as Apple Music, iCloud, and Apple Pay. Apple's products run internally developed software, and we believe this integration of hardware, software, and services often allows the firm to maintain premium pricing for its devices. Apple's products are distributed online as well as through company-owned stores and third-party retailers.
thanks
Sun Apr 8, 2018 1:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
This appears to do the trick:
=smfStrExtr(smfGetTagContent("https://www.gurufocus.com/stock/AAPL
","div",-1,"Location:"),"</table>","<div",1)
On Sun, Apr 8, 2018 at 12:49 AM, lawrence.leesh@
...
wrote:
> Is your SMFGetTagContent addin able to get from this url
> https://www.gurufocus.com/stock/AAPL
>
> the following?
>
> Apple Inc is designs, manufactures and markets mobile communication and
> media devices and personal computers, and sells a variety of related
> software, services, accessories, networking solutions and third-party
> digital content and applications.
>
>
> Apple designs consumer electronic devices, including smartphones (iPhone),
> tablets (iPad), PCs (Mac), smartwatches (Watch), and TV boxes (Apple TV),
> as well as a variety of services such as Apple Music, iCloud, and Apple
> Pay. Apple's products run internally developed software, and we believe
> this integration of hardware, software, and services often allows the firm
> to maintain premium pricing for its devices. Apple's products are
> distributed online as well as through company-owned stores and third-party
> retailers.
>
>
>
>
=smfStrExtr(smfGetTagContent("https://www.gurufocus.com/stock/AAPL
","div",-1,"Location:"),"</table>","<div",1)
On Sun, Apr 8, 2018 at 12:49 AM, lawrence.leesh@
...
wrote:
> Is your SMFGetTagContent addin able to get from this url
> https://www.gurufocus.com/stock/AAPL
>
> the following?
>
> Apple Inc is designs, manufactures and markets mobile communication and
> media devices and personal computers, and sells a variety of related
> software, services, accessories, networking solutions and third-party
> digital content and applications.
>
>
> Apple designs consumer electronic devices, including smartphones (iPhone),
> tablets (iPad), PCs (Mac), smartwatches (Watch), and TV boxes (Apple TV),
> as well as a variety of services such as Apple Music, iCloud, and Apple
> Pay. Apple's products run internally developed software, and we believe
> this integration of hardware, software, and services often allows the firm
> to maintain premium pricing for its devices. Apple's products are
> distributed online as well as through company-owned stores and third-party
> retailers.
>
>
>
>
Sun Apr 8, 2018 5:56 am (PDT) . Posted by:
lawrence.leesh
I got #VALUE when I key in the formula. Am I missing something? Thanks.
Sun Apr 8, 2018 10:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm. I just cut and pasted it from the Yahoo group and it worked fine.
It could be that your web page is different than mine because I'm a
subscriber? Or are you using an older version of the add-in? The last "1"
parameter in smfStrExtr() was added late last year. If you don't have that
update in your version of the add-in, you would get a #VALUE! error.
On Sun, Apr 8, 2018 at 5:56 AM, lawrence.leesh@
...
wrote:
>
> I got #VALUE when I key in the formula. Am I missing something? Thanks..
>
>
>
It could be that your web page is different than mine because I'm a
subscriber? Or are you using an older version of the add-in? The last "1"
parameter in smfStrExtr() was added late last year. If you don't have that
update in your version of the add-in, you would get a #VALUE! error.
On Sun, Apr 8, 2018 at 5:56 AM, lawrence.leesh@
...
wrote:
>
> I got #VALUE when I key in the formula. Am I missing something? Thanks..
>
>
>
Sun Apr 8, 2018 2:20 pm (PDT) . Posted by:
lawrence.leesh
I am also a subscriber so I think we are seeing the same page. However, I am using an old version of the plugin. Could you pls give me the link to download the latest? I could not find it in the Files area. Thanks.
Sun Apr 8, 2018 3:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's on the website now:
http://ogres-crypt.com/SMF/
On Sun, Apr 8, 2018 at 2:20 PM, lawrence.leesh@
...
wrote:
>
> I am also a subscriber so I think we are seeing the same page. However, I
> am using an old version of the plugin. Could you pls give me the link to
> download the latest? I could not find it in the Files area. Thanks.
>
http://ogres-crypt.com/SMF/
On Sun, Apr 8, 2018 at 2:20 PM, lawrence.leesh@
...
wrote:
>
> I am also a subscriber so I think we are seeing the same page. However, I
> am using an old version of the plugin. Could you pls give me the link to
> download the latest? I could not find it in the Files area. Thanks.
>
Tue Apr 10, 2018 6:57 pm (PDT) . Posted by:
"Alechia Rocheleau" alliejuice87
I have no idea why I keep getting these emails and I also don't know how to make them stop.
Please help
Sent from Yahoo Mail for iPhone
Please help
Sent from Yahoo Mail for iPhone
Wed Apr 11, 2018 8:46 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Somehow you have subscribed to the yahoo group
Try one of these 3 methods to unsubscribe:
I have not used any of them so I can't be sure they work but worth a try.
Unsubscribe From Emails | Instantly With One Click <https://join.unroll.me/?utm_campaign=google2018>
Adjoin.unroll.me/
· Ditch the emails you don't want. Keep the ones you do. Get started today!
Download App · Sign Up Online
* FAQs <https://unroll.me/faq/>
* Software Features <https://unroll.me/features/>
* Support Center <https://support.unroll.me/hc/en-us>
* Get Mobile App <https://unroll.me/app/>
* Log In <https://unroll.me/a/login>
· How Do I Unsubscribe | Search How Do I Unsubscribe. <https://www.informationvine.com/index?qsrc=999&qo=semQuery&ad=semD&o=603851&l=sem&askid=ff423ece-7a81-4baa-b75a-d3b0fda6ce83-0-iv_gsb&q=how%20do%20i%20unsubscribe&dqi=&am=broad&an=google_s>
Adwww.informationvine.com/Answers
· How Do I Unsubscribe.
Quick & Easy Answers · Find Relevant Information
· Mass Unsubscribe Email Tool | Get <https://getunsubscriber.com/> Unsubscriber
Adwww.getunsubscriber.com/
Fast and Free Email Plugin. Remove and Prevent Unwanted Email.
Under 1 Minute to Sign Up · It's Free! · Fast & Easy To Install · Over 6 Million Users
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 10, 2018 9:53 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Unsubscribe
I have no idea why I keep getting these emails and I also don't know how to make them stop.
Please help
Sent from Yahoo Mail for iPhone <https://overview.mail.yahoo.com/?.src=iOS>
Try one of these 3 methods to unsubscribe:
I have not used any of them so I can't be sure they work but worth a try.
Unsubscribe From Emails | Instantly With One Click <https://join.unroll.me/?utm_campaign=google2018>
Adjoin.unroll.me/
· Ditch the emails you don't want. Keep the ones you do. Get started today!
Download App · Sign Up Online
* FAQs <https://unroll.me/faq/>
* Software Features <https://unroll.me/features/>
* Support Center <https://support.unroll.me/hc/en-us>
* Get Mobile App <https://unroll.me/app/>
* Log In <https://unroll.me/a/login>
· How Do I Unsubscribe | Search How Do I Unsubscribe. <https://www.informationvine.com/index?qsrc=999&qo=semQuery&ad=semD&o=603851&l=sem&askid=ff423ece-7a81-4baa-b75a-d3b0fda6ce83-0-iv_gsb&q=how%20do%20i%20unsubscribe&dqi=&am=broad&an=google_s>
Adwww.informationvine.com/Answers
· How Do I Unsubscribe.
Quick & Easy Answers · Find Relevant Information
· Mass Unsubscribe Email Tool | Get <https://getunsubscriber.com/> Unsubscriber
Adwww.getunsubscriber.com/
Fast and Free Email Plugin. Remove and Prevent Unwanted Email.
Under 1 Minute to Sign Up · It's Free! · Fast & Easy To Install · Over 6 Million Users
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 10, 2018 9:53 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Unsubscribe
I have no idea why I keep getting these emails and I also don't know how to make them stop.
Please help
Sent from Yahoo Mail for iPhone <https://overview.mail.yahoo.com/?.src=iOS>
Wed Apr 11, 2018 9:37 am (PDT) . Posted by:
"Craig Passow" passow
Why not just use the unsubscribe link at the bottom of every group message?
On 4/11/2018 10:43 AM, 'Kermit W. Prather' kermitp@tampabay.rr.com
[smf_addin] wrote:
>
>
> Somehow you have subscribed to the yahoo group
>
> Try one of these 3 methods to unsubscribe:
>
> I have not used any of them so I can't be sure they work but worth a try.
>
>
>
>
>
> *Unsubscribe From Emails | Instantly With One Click
> <https://join.unroll.me/?utm_campaign=google2018>*
>
> Ad/join.unroll.me////
>
> · Ditch the emails you don't want. Keep the ones you do. Get started
> today!
>
> Download App · Sign Up Online
>
> * FAQs <https://unroll.me/faq/>
> * Software Features <https://unroll.me/features/>
> * Support Center <https://support.unroll.me/hc/en-us>
> * Get Mobile App <https://unroll.me/app/>
> * Log In <https://unroll.me/a/login>
>
> *·** How Do I Unsubscribe | Search How Do I Unsubscribe.
> <https://www.informationvine.com/index?qsrc=999&qo=semQuery&ad=semD&o=603851&l=sem&askid=ff423ece-7a81-4baa-b75a-d3b0fda6ce83-0-iv_gsb&q=how%20do%20i%20unsubscribe&dqi=&am=broad&an=google_s>*
>
> Ad/www.informationvine.com/Answers/
>
> · How Do I *Unsubscribe*.
>
> Quick & Easy Answers · Find Relevant Information
>
> *·** Mass Unsubscribe Email Tool | Get Unsubscriber
> <https://getunsubscriber.com/>*
>
> Ad/www.getunsubscriber.com//
>
> Fast and Free Email *Plugin*. Remove and Prevent Unwanted Email.
>
> Under 1 Minute to Sign Up · It's Free! · Fast & Easy To Install · Over
> 6 Million Users
>
>
>
> *From:*smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Tuesday, April 10, 2018 9:53 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] Unsubscribe
>
>
>
>
>
> I have no idea why I keep getting these emails and I also don't know
> how to make them stop.
>
>
>
> Please help
>
>
> Sent from Yahoo Mail for iPhone
> <https://overview.mail.yahoo.com/?.src=iOS>
>
>
>
>
>
On 4/11/2018 10:43 AM, 'Kermit W. Prather' kermitp@tampabay.rr.com
[smf_addin] wrote:
>
>
> Somehow you have subscribed to the yahoo group
>
> Try one of these 3 methods to unsubscribe:
>
> I have not used any of them so I can't be sure they work but worth a try.
>
>
>
>
>
> *Unsubscribe From Emails | Instantly With One Click
> <https://join.unroll.me/?utm_campaign=google2018>*
>
> Ad/join.unroll.me////
>
> · Ditch the emails you don't want. Keep the ones you do. Get started
> today!
>
> Download App · Sign Up Online
>
> * FAQs <https://unroll.me/faq/>
> * Software Features <https://unroll.me/features/>
> * Support Center <https://support.unroll.me/hc/en-us>
> * Get Mobile App <https://unroll.me/app/>
> * Log In <https://unroll.me/a/login>
>
> *·** How Do I Unsubscribe | Search How Do I Unsubscribe.
> <https://www.informationvine.com/index?qsrc=999&qo=semQuery&ad=semD&o=603851&l=sem&askid=ff423ece-7a81-4baa-b75a-d3b0fda6ce83-0-iv_gsb&q=how%20do%20i%20unsubscribe&dqi=&am=broad&an=google_s>*
>
> Ad/www.informationvine.com/Answers/
>
> · How Do I *Unsubscribe*.
>
> Quick & Easy Answers · Find Relevant Information
>
> *·** Mass Unsubscribe Email Tool | Get Unsubscriber
> <https://getunsubscriber.com/>*
>
> Ad/www.getunsubscriber.com//
>
> Fast and Free Email *Plugin*. Remove and Prevent Unwanted Email.
>
> Under 1 Minute to Sign Up · It's Free! · Fast & Easy To Install · Over
> 6 Million Users
>
>
>
> *From:*smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Tuesday, April 10, 2018 9:53 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] Unsubscribe
>
>
>
>
>
> I have no idea why I keep getting these emails and I also don't know
> how to make them stop.
>
>
>
> Please help
>
>
> Sent from Yahoo Mail for iPhone
> <https://overview.mail.yahoo.com/?.src=iOS>
>
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar