13 New Messages
Digest #2436
Messages
Fri Dec 14, 2012 7:30 am (PST) . Posted by:
"Randy Harmelink" rharmelink
With FireFox, I just right -clicked on the area, chose the "This Frame"
option, and clicked on "Open Frame in New Tab". Then the URL is in the
address bar.
Other browsers should have similar options.
On Fri, Dec 14, 2012 at 8:21 AM, wongkayau <wongkayau@yahoo.com > wrote:
>
> You are the best! it works! Thanks a lot. By the way, how do u find the
> link? Thanks!
>
option, and clicked on "Open Frame in New Tab". Then the URL is in the
address bar.
Other browsers should have similar options.
On Fri, Dec 14, 2012 at 8:21 AM, wongkayau <wongkayau@yahoo.
>
> You are the best! it works! Thanks a lot. By the way, how do u find the
> link? Thanks!
>
Fri Dec 14, 2012 7:36 am (PST) . Posted by:
"wongkayau" wongkayau
awesome! much appreciated.
have a good day!
laurent
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> With FireFox, I just right -clicked on the area, chose the "This Frame"
> option, and clicked on "Open Frame in New Tab". Then the URL is in the
> address bar.
>
> Other browsers should have similar options.
>
> On Fri, Dec 14, 2012 at 8:21 AM, wongkayau <wongkayau@...> wrote:
>
> >
> > You are the best! it works! Thanks a lot. By the way, how do u find the
> > link? Thanks!
> >
>
have a good day!
laurent
--- In smf_addin@yahoogrou
>
> With FireFox, I just right -clicked on the area, chose the "This Frame"
> option, and clicked on "Open Frame in New Tab". Then the URL is in the
> address bar.
>
> Other browsers should have similar options.
>
> On Fri, Dec 14, 2012 at 8:21 AM, wongkayau <wongkayau@.
>
> >
> > You are the best! it works! Thanks a lot. By the way, how do u find the
> > link? Thanks!
> >
>
Fri Dec 14, 2012 7:42 am (PST) . Posted by:
"Stock Jock" stockjocktrader
I can understand that; however, I can't find very much documentation on
how to use it and I may have to store my downloaded data in a text file
or database in order that the function can calculate the indicator
values. Does your addin have a function to store quote data into a
storage file as it gets downloaded?
------------
--- In smf_addin@yahoogrou
wrote:
I stopped development of that function when I found out about the free
TA-Lib add-in. I decided there was no reason to reinvent the wheel when
it was free elsewhere.
Fri Dec 14, 2012 8:21 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Storing quotes is something you'd have to write your own VBA routine for.
For TA-Lib, just use the function wizard when you use the function -- it
tells you what each parameter needs to be.
http://ta-lib.org/function.html
http://ta-lib.org/excel_doc.html
On Fri, Dec 14, 2012 at 8:42 AM, Stock Jock <stockjocktrader@yahoo.com >wrote:
> I can understand that; however, I can't find very much documentation on
> how to use it and I may have to store my downloaded data in a text file or
> database in order that the function can calculate the indicator values.
> Does your addin have a function to store quote data into a storage file as
> it gets downloaded?
>
For TA-Lib, just use the function wizard when you use the function -- it
tells you what each parameter needs to be.
http://ta-lib.
http://ta-lib.
On Fri, Dec 14, 2012 at 8:42 AM, Stock Jock <stockjocktrader@
> I can understand that; however, I can't find very much documentation on
> how to use it and I may have to store my downloaded data in a text file or
> database in order that the function can calculate the indicator values.
> Does your addin have a function to store quote data into a storage file as
> it gets downloaded?
>
Fri Dec 14, 2012 7:59 am (PST) . Posted by:
"Stock Jock" stockjocktrader
I use Virtualbox excessively, mainly to supplement as an isolated
operating system (OS) to protect my main OS from viruses or any system
corrupting influence. I use to use Sandboxie to do this, but with
Virtualbox I can create templates for specific purposes (i.e. Graphic
Design, Trading, Programming) and I can clone them as a backup in the
case they get corrupted.
There is a Virtualbox for each of the common operating system that is
free.
https://www.
<https://www.
https://forums.
http://www.win-
ser-projekte/
<http://www.win-
user-projekte/
There is a Portable Virtualbox
http://www.vbox.
------------
--- In smf_addin@yahoogrou
Search through the messages. I think there has be success with
Parallels and VirtualBox.
Ron Spruell
Fri Dec 14, 2012 5:05 pm (PST) . Posted by:
"Ron Spruell" hashky
I doubt it. With both VirtualBox and Prallels, you have to have Windows.
>________________________________
> From: james morlock <JimMorlock@optonline.net >
>To: smf_addin@yahoogroups.com
>Sent: Friday, December 14, 2012 8:44 AM
>Subject: Re: [smf_addin] Any success using this on a Mac?
>
>
>
> If these products work on a Mac does that also mean they are likely to run on an iPad? I have avoided Mac products because most investing software is Windows based.
>
>Jim
>
>
>On Fri, Dec 14, 2012 at 8:22 AM, Ron Spruell wrote:
>
> Search through the messages. I think there has be success with Parallels and VirtualBox.
>
>Ron Spruell
>
>
>
>___________________________________
>
>From: peterson8484 <peterson8484@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, December 11, 2012 10:27 AM
>Subject: [smf_addin] Any success using this on a Mac?
>
> I'm switching from a PC to a Mac and before I resort to a solution that will run Windows on my Mac I wanted to check:
>
>Has anyone found a way to successfully use this add-in on a Mac?
>
>
>
>
>
>
>
>___________
> From: james morlock <JimMorlock@optonlin
>To: smf_addin@yahoogrou
>Sent: Friday, December 14, 2012 8:44 AM
>Subject: Re: [smf_addin] Any success using this on a Mac?
>
>
>
> If these products work on a Mac does that also mean they are likely to run on an iPad? I have avoided Mac products because most investing software is Windows based.
>
>Jim
>
>
>On Fri, Dec 14, 2012 at 8:22 AM, Ron Spruell wrote:
>
> Search through the messages. I think there has be success with Parallels and VirtualBox.
>
>Ron Spruell
>
>
>
>___________
>
>From: peterson8484 <peterson8484@
>To: smf_addin@yahoogrou
>Sent: Tuesday, December 11, 2012 10:27 AM
>Subject: [smf_addin] Any success using this on a Mac?
>
> I'm switching from a PC to a Mac and before I resort to a solution that will run Windows on my Mac I wanted to check:
>
>Has anyone found a way to successfully use this add-in on a Mac?
>
>
>
>
>
>
>
Fri Dec 14, 2012 10:52 pm (PST) . Posted by:
"randc_1yh" randc_1yh
I have been running a number of Windows-only programs on my Mac for years, including a macro suite for Excel that imports historic and real time stock data. I use Fusion software by VM Ware to create a virtual PC on my Mac, which will run any version of Windows software (I am still using XP) and most Windows software. My Windows programs (Microsoft Office mainly) actually run faster on my MacBook Pro than on my Windows PC. I haven't yet tried this particular addin however, but will be doing that very soon.
--- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
>
> I doubt it. With both VirtualBox and Prallels, you have to have Windows.
>
>
>
>
>
> >________________________________
> > From: james morlock <JimMorlock@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Friday, December 14, 2012 8:44 AM
> >Subject: Re: [smf_addin] Any success using this on a Mac?
> >
> >
> >Â
> > If these products work on a Mac does that also mean they are likely to run on an iPad? I have avoided Mac products because most investing software is Windows based.
> >
> >Jim
> >
> >
> >On Fri, Dec 14, 2012 at 8:22 AM, Ron Spruell wrote:
> >
> >  Search through the messages. I think there has be success with Parallels and VirtualBox.
> >
> >Ron Spruell
> >
> >
> >
> >___________________________________
> >
> >From: peterson8484 <peterson8484@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Tuesday, December 11, 2012 10:27 AM
> >Subject: [smf_addin] Any success using this on a Mac?
> >
> >Â I'm switching from a PC to a Mac and before I resort to a solution that will run Windows on my Mac I wanted to check:
> >
> >Has anyone found a way to successfully use this add-in on a Mac?
> >
> >
> >
> >
> >
> >
> >
>
--- In smf_addin@yahoogrou
>
> I doubt it. With both VirtualBox and Prallels, you have to have Windows.
>
>
>
>
>
> >___________
> > From: james morlock <JimMorlock@
> >To: smf_addin@yahoogrou
> >Sent: Friday, December 14, 2012 8:44 AM
> >Subject: Re: [smf_addin] Any success using this on a Mac?
> >
> >
> >Â
> > If these products work on a Mac does that also mean they are likely to run on an iPad? I have avoided Mac products because most investing software is Windows based.
> >
> >Jim
> >
> >
> >On Fri, Dec 14, 2012 at 8:22 AM, Ron Spruell wrote:
> >
> >  Search through the messages. I think there has be success with Parallels and VirtualBox.
> >
> >Ron Spruell
> >
> >
> >
> >___________
> >
> >From: peterson8484 <peterson8484@
> >To: smf_addin@yahoogrou
> >Sent: Tuesday, December 11, 2012 10:27 AM
> >Subject: [smf_addin] Any success using this on a Mac?
> >
> >Â I'm switching from a PC to a Mac and before I resort to a solution that will run Windows on my Mac I wanted to check:
> >
> >Has anyone found a way to successfully use this add-in on a Mac?
> >
> >
> >
> >
> >
> >
> >
>
Fri Dec 14, 2012 8:04 am (PST) . Posted by:
"Stock Jock" stockjocktrader
In using the RCHGetYahooQuotes() function, can I use a "range name"
instead of the range cells? Most of time, I perfer to give a name to
the ranges that I use.
instead of the range cells? Most of time, I perfer to give a name to
the ranges that I use.
Fri Dec 14, 2012 8:25 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sure. Usage of the user-defined functions is almost the same as a native
EXCEL function.
On Fri, Dec 14, 2012 at 9:04 AM, Stock Jock <stockjocktrader@yahoo.com >wrote:
>
> In using the RCHGetYahooQuotes() function, can I use a "range name"
> instead of the range cells? Most of time, I perfer to give a name to the
> ranges that I use.
>
EXCEL function.
On Fri, Dec 14, 2012 at 9:04 AM, Stock Jock <stockjocktrader@
>
> In using the RCHGetYahooQuotes(
> instead of the range cells? Most of time, I perfer to give a name to the
> ranges that I use.
>
Fri Dec 14, 2012 1:30 pm (PST) . Posted by:
"fythras" fythras
Sorry, this will be the last question I swear. I set the add-in as a reference library and that's working great. However whenever I try to use the smfGetEconData it isn't working. For example, I have
Data = smfGetEconData("GDP", DATE(2012,12,12)). The problem I'm having is Date being a VBA function it errors out. Now I tried doing something like GDPDate = "DATE(2012,12,12)" but that doesn't work whether GDP is declared as a variant or string.
Thank you for you help. I just got out of the Peace Corps a couple months ago so this is the first time I'm going back to your program/VBA in 3 years.
thanks!
Justin
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> If you want to use add-in functions within your own VBA code, you need to
> set the add-in as a reference library for the VBA project (> Tools >
> References).
>
> On Thu, Dec 13, 2012 at 1:29 PM, fythras <fythras@...> wrote:
>
> > Yeah this is true. Thank you! I've changed it around some. I want to
> > update the econ data every time the workbook opens. I've forgotten some of
> > my VBA code...if I want to call your function smfGetEconData from inside a
> > sub...how do I do this. I was trying some stuff but the editor wasn't
> > recognizing it.
> >
>
Data = smfGetEconData(
Thank you for you help. I just got out of the Peace Corps a couple months ago so this is the first time I'm going back to your program/VBA in 3 years.
thanks!
Justin
--- In smf_addin@yahoogrou
>
> If you want to use add-in functions within your own VBA code, you need to
> set the add-in as a reference library for the VBA project (> Tools >
> References).
>
> On Thu, Dec 13, 2012 at 1:29 PM, fythras <fythras@...
>
> > Yeah this is true. Thank you! I've changed it around some. I want to
> > update the econ data every time the workbook opens. I've forgotten some of
> > my VBA code...if I want to call your function smfGetEconData from inside a
> > sub...how do I do this. I was trying some stuff but the editor wasn't
> > recognizing it.
> >
>
Fri Dec 14, 2012 2:38 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That's because DATE() is a different function in VBA than in EXCEL. In VBA,
there are no parameters for the function, it just returns the current date.
In VBA, you want:
DateSerial(2012, 12, 12)
...because EXCEL uses serial dates.
So, try:
Data = smfGetEconData("GDP", DateSerial(2012, 12, 12))
However, that will return a 3 by 1 array (value, date, description). If you
want JUST the value, it would be:
Data = smfGetEconData("GDP", DateSerial(2012, 12, 12))(1)
However, also note that the file's latest GDP value is actually from July
1st of this year:
=smfGetEconData("GDP", "Date Range")
On Fri, Dec 14, 2012 at 2:30 PM, fythras <fythras@yahoo.com > wrote:
> Sorry, this will be the last question I swear. I set the add-in as a
> reference library and that's working great. However whenever I try to use
> the smfGetEconData it isn't working. For example, I have
>
> Data = smfGetEconData("GDP", DATE(2012,12,12)). The problem I'm having is
> Date being a VBA function it errors out. Now I tried doing something like
> GDPDate = "DATE(2012,12,12)" but that doesn't work whether GDP is declared
> as a variant or string.
>
> Thank you for you help. I just got out of the Peace Corps a couple months
> ago so this is the first time I'm going back to your program/VBA in 3 years.
>
there are no parameters for the function, it just returns the current date.
In VBA, you want:
DateSerial(2012, 12, 12)
...because EXCEL uses serial dates.
So, try:
Data = smfGetEconData(
However, that will return a 3 by 1 array (value, date, description)
want JUST the value, it would be:
Data = smfGetEconData(
However, also note that the file's latest GDP value is actually from July
1st of this year:
=smfGetEconData(
On Fri, Dec 14, 2012 at 2:30 PM, fythras <fythras@yahoo.
> Sorry, this will be the last question I swear. I set the add-in as a
> reference library and that's working great. However whenever I try to use
> the smfGetEconData it isn't working. For example, I have
>
> Data = smfGetEconData(
> Date being a VBA function it errors out. Now I tried doing something like
> GDPDate = "DATE(2012,12,
> as a variant or string.
>
> Thank you for you help. I just got out of the Peace Corps a couple months
> ago so this is the first time I'm going back to your program/VBA in 3 years.
>
Fri Dec 14, 2012 3:01 pm (PST) . Posted by:
"fythras" fythras
Wow, that worked perfectly! Yeah I did see that the last gdp was from July but I'm setting this up so that each time I open the spreadsheet it updates values in the spreadsheet if need be and I see that even if you reference a date that isn't in the data yet, a newer date, it still gives me the most recent available data which is cool.
Thanks! I'll upload this after I'm done with if it, if it is of interest to people. I found data on another site going back to the late 1700s. So I'm just creating an economic snapshot of now and a historical snapshot of 6 or 7 different years throughout our history. Users can can change the the years and the data for those years will be imported or someone can expand the range if need be.
Anyway, thanks again! I really appreciate your help. I'm really glad to see how this much everything here has progressed since I was gone.
Justin
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's because DATE() is a different function in VBA than in EXCEL. In VBA,
> there are no parameters for the function, it just returns the current date.
> In VBA, you want:
>
> DateSerial(2012, 12, 12)
>
> ...because EXCEL uses serial dates.
>
> So, try:
>
> Data = smfGetEconData("GDP", DateSerial(2012, 12, 12))
>
> However, that will return a 3 by 1 array (value, date, description). If you
> want JUST the value, it would be:
>
> Data = smfGetEconData("GDP", DateSerial(2012, 12, 12))(1)
>
> However, also note that the file's latest GDP value is actually from July
> 1st of this year:
>
> =smfGetEconData("GDP", "Date Range")
>
> On Fri, Dec 14, 2012 at 2:30 PM, fythras <fythras@...> wrote:
>
> > Sorry, this will be the last question I swear. I set the add-in as a
> > reference library and that's working great. However whenever I try to use
> > the smfGetEconData it isn't working. For example, I have
> >
> > Data = smfGetEconData("GDP", DATE(2012,12,12)). The problem I'm having is
> > Date being a VBA function it errors out. Now I tried doing something like
> > GDPDate = "DATE(2012,12,12)" but that doesn't work whether GDP is declared
> > as a variant or string.
> >
> > Thank you for you help. I just got out of the Peace Corps a couple months
> > ago so this is the first time I'm going back to your program/VBA in 3 years.
> >
>
Thanks! I'll upload this after I'm done with if it, if it is of interest to people. I found data on another site going back to the late 1700s. So I'm just creating an economic snapshot of now and a historical snapshot of 6 or 7 different years throughout our history. Users can can change the the years and the data for those years will be imported or someone can expand the range if need be.
Anyway, thanks again! I really appreciate your help. I'm really glad to see how this much everything here has progressed since I was gone.
Justin
--- In smf_addin@yahoogrou
>
> That's because DATE() is a different function in VBA than in EXCEL. In VBA,
> there are no parameters for the function, it just returns the current date.
> In VBA, you want:
>
> DateSerial(2012, 12, 12)
>
> ...because EXCEL uses serial dates.
>
> So, try:
>
> Data = smfGetEconData(
>
> However, that will return a 3 by 1 array (value, date, description)
> want JUST the value, it would be:
>
> Data = smfGetEconData(
>
> However, also note that the file's latest GDP value is actually from July
> 1st of this year:
>
> =smfGetEconData(
>
> On Fri, Dec 14, 2012 at 2:30 PM, fythras <fythras@...
>
> > Sorry, this will be the last question I swear. I set the add-in as a
> > reference library and that's working great. However whenever I try to use
> > the smfGetEconData it isn't working. For example, I have
> >
> > Data = smfGetEconData(
> > Date being a VBA function it errors out. Now I tried doing something like
> > GDPDate = "DATE(2012,12,
> > as a variant or string.
> >
> > Thank you for you help. I just got out of the Peace Corps a couple months
> > ago so this is the first time I'm going back to your program/VBA in 3 years.
> >
>
Fri Dec 14, 2012 4:31 pm (PST) . Posted by:
"lexstar" lexstar
I downloaded MS Office 2013 trial version on my one computer running Windows 8 and the problem went away on one computer.
The other computer running Windows 7 and MS Office 2010 still has the problem.
--- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
>
> I don't have a clue what you are talking about, but my suggestion would be to go through your settings in Excel, and make sure it isn't locked down.
> http://bribg.pbworks.com/w/file/50396066/Step-by-Step%20SMF%20Add-In.doc
>
> Then reboot.
>
> Ron Spruell
>
>
>
>
>
> >________________________________
> > From: lexstar <lexstar@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Wednesday, December 12, 2012 9:49 AM
> >Subject: [smf_addin] Re: Excel 2010 crashes every time "Enable Editing" is clicked
> >
> >
> >Â
> >And, if I'm not having this problem, I'm getting this other problem:
> >
> >"Microsoft Visual Basic for Applications.... Can't find project or library".
> >
> >Man, I'm totally screwed today... Any help would be greatly appreciated. I've looked online, and tried some of the stuffs they said to try...but none has worked so far.
> >
> >Frustrating.
> >
> >--- In smf_addin@yahoogroups.com , "lexstar" <lexstar@> wrote:
> >>
> >> Hello. Anyway have a way to help me out? My Excel 2010 workbook crashes everytime the Protected View shows up with "Enable Editing" and I clicked on it.
> >>
> >> I did some search online and someone came up with this code, but where do you put in order to make it work?
> >>
> >> ............One additional note that I just stumbled on was that the code will error if the workbook isn't in "ProtectedView". So to avoid this the following code will only enable editing if the workbook has "ProtectedView" enabled.
> >>
> >> Otherwise the enable editing is skipped and everyone is happy.
> >>
> >> If Application.ProtectedViewWindows.Count > 0 Then
> >> Application.ActiveProtectedViewWindow.Edit
> >> End If
> >>
> >>
> >> Any help is much appreciated.
> >>
> >
> >
> >
> >
> >
>
The other computer running Windows 7 and MS Office 2010 still has the problem.
--- In smf_addin@yahoogrou
>
> I don't have a clue what you are talking about, but my suggestion would be to go through your settings in Excel, and make sure it isn't locked down.
> http://bribg.
>
> Then reboot.
>
> Ron Spruell
>
>
>
>
>
> >___________
> > From: lexstar <lexstar@...
> >To: smf_addin@yahoogrou
> >Sent: Wednesday, December 12, 2012 9:49 AM
> >Subject: [smf_addin] Re: Excel 2010 crashes every time "Enable Editing" is clicked
> >
> >
> >Â
> >And, if I'm not having this problem, I'm getting this other problem:
> >
> >"Microsoft Visual Basic for Applications.
> >
> >Man, I'm totally screwed today... Any help would be greatly appreciated. I've looked online, and tried some of the stuffs they said to try...but none has worked so far.
> >
> >Frustrating.
> >
> >--- In smf_addin@yahoogrou
> >>
> >> Hello. Anyway have a way to help me out? My Excel 2010 workbook crashes everytime the Protected View shows up with "Enable Editing" and I clicked on it.
> >>
> >> I did some search online and someone came up with this code, but where do you put in order to make it work?
> >>
> >> ............
> >>
> >> Otherwise the enable editing is skipped and everyone is happy.
> >>
> >> If Application.
> >> Application.
> >> End If
> >>
> >>
> >> Any help is much appreciated.
> >>
> >
> >
> >
> >
> >
>
Tidak ada komentar:
Posting Komentar