Messages In This Digest (6 Messages)
- 1.1.
- Re: New file uploaded to smf_addin From: whitney
- 1.2.
- Re: New file uploaded to smf_addin From: Randy Harmelink
- 2a.
- Re: Macro help From: d.sweitzer22
- 2b.
- Re: Macro help From: Randy Harmelink
- 3.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 3.2.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
Messages
- 1.1.
-
Re: New file uploaded to smf_addin
Posted by: "whitney" thelancour@yahoo.com thelancour
Thu Apr 12, 2012 10:56 am (PDT)
Wow Simply amazing!! Thank you for your help. But to add to the craziness, how in the world can I pull data from this webpage to cross reference with the other data I have => https://www.broward.realfore close.com/ index.cfm? zaction=AUCTION& Zmethod=PREVIEW& AUCTIONDATE= 04/27/2012
Are these all image/ Thats what I seem to get using smfgettagcontent??????????
--- In smf_addin@yahoogroups.com , smf_addin@yahoogroups.com wrote:
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Add-In Version 1.2/RCH_Stock_Market_Functions .xla
> Uploaded by : rharmelink <rharmelink@...>
> Description : Version 1.2f of the add-in
>
> You can access this file at the URL:
> http://groups.yahoo.com/ group/smf_ addin/files/ Add-In%20Version %201.2/RCH_ Stock_Market_ Functions. xla
>
> To learn more about file sharing for your group, please visit:
> http://help.yahoo.com/ help/us/groups/ files
>
> Regards,
>
> rharmelink <rharmelink@...>
>
- 1.2.
-
Re: New file uploaded to smf_addin
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Apr 12, 2012 1:19 pm (PDT)
Sorry, but it looks like the data is put onto the web page dynamically, so
the source code of the web page doesn't have anything for the add-in to
extract.
On Thu, Apr 12, 2012 at 10:56 AM, whitney <thelancour@yahoo.com > wrote:
>
> But to add to the craziness, how in the world can I pull data from this
> webpage to cross reference with the other data I have =>
> https://www.broward.realfore close.com/ index.cfm? zaction=AUCTION& Zmethod=PREVIEW& AUCTIONDATE= 04/27/2012
>
> Are these all image/ Thats what I seem to get using
> smfgettagcontent??????????
>
- 2a.
-
Re: Macro help
Posted by: "d.sweitzer22" d.sweitzer22@yahoo.com d.sweitzer22
Thu Apr 12, 2012 11:59 am (PDT)
Thanks for getting back to me.
This macro is to pull in historical quotes just from a certain day (usually the end of the month) to be entered into a model. The macro I am using now is:
Sub HistoricalQuote()
'
' HistoricalQuote Macro
'
'
Range("C7").Select
ActiveCell.FormulaR1C1 = _
"=RCHGetYahooHistory(RC[-2], R14C[11], R14C[12], R14C[13], R14C[11], R14C[12], R14C[13], ""d"",""C" ",0,0,0)"
Range("C7").Select
Selection.AutoFill Destination:=Range("C7: C75"), Type:=xlFillDefault
Range("C7:C75").Select
End Sub
This just changes the cell to that formula. What I am trying to do is have the just output of formula display in that suit instead of change the cell to that formula. For example the cell right now displays the number 10.02 but the cell contains the formula =RCHGetYahooHistory(A7,N14,O14, P14,N14,O14, P14,"d"," C",0,0,0)
I want the cell just to contain the number.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Please tell me you're not retrieving historical data one day at a time?
>
> You should post your macro code so people have some idea of what you have
> already.
>
> On Tue, Apr 10, 2012 at 1:56 PM, d.sweitzer22 <d.sweitzer22@...>wrote:
>
> > Hey, I am new to VBA and I am trying to write a macro using your
> > getyahoohistory function. What I have now is a column starting in A7 with
> > ticker symbols and then the date I want in an array with the year(in N14),
> > month(in O14), and day(in P14). What I am trying to do is have the have the
> > column starting at C7 display the closing price for each ticker at the set
> > date, without it putting the function itself in the cell. Right now I can
> > get the number but it changes that cell into the function instead of just
> > displaying the number.
> >
> > The parameters of the function im using are:
> >
> > =RCHGetYahooHistory(A7,N14,O14, P14,N14,O14, P14,"d"," C",0,0,0)
> >
> > for the first ticker.
> >
> > If anyone has any spare time I would greatly appreciate any help.
> >
>
- 2b.
-
Re: Macro help
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Apr 12, 2012 1:24 pm (PDT)
Then just set the value of the cell instead of creating a formula.
I would think you'd be better off using the smfPricesByDates() function.
On Thu, Apr 12, 2012 at 11:59 AM, d.sweitzer22 <d.sweitzer22@yahoo.com >wrote:
>
> This macro is to pull in historical quotes just from a certain day
> (usually the end of the month) to be entered into a model. The macro I am
> using now is:
>
> Sub HistoricalQuote()
> '
> ' HistoricalQuote Macro
> '
> '
> Range("C7").Select
> ActiveCell.FormulaR1C1 = _
>
> "=RCHGetYahooHistory(RC[-2], R14C[11], R14C[12], R14C[13], R14C[11], R14C[12], R14C[13], ""d"",""C" ",0,0,0)"
> Range("C7").Select
> Selection.AutoFill Destination:=Range("C7: C75"), Type:=xlFillDefault
> Range("C7:C75").Select
> End Sub
>
>
> This just changes the cell to that formula. What I am trying to do is
> have the just output of formula display in that suit instead of change the
> cell to that formula. For example the cell right now displays the number
> 10.02 but the cell contains the formula
> =RCHGetYahooHistory(A7,N14,O14, P14,N14,O14, P14,"d"," C",0,0,0)
> I want the cell just to contain the number.
>
- 3.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Thu Apr 12, 2012 7:04 pm (PDT)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Money making worksheets/FUTURES.xlsm
Uploaded by : digsupply <picsound@gmail.com >
Description : QueryTables with Real Time Streaming Commodity Prices, Energy - Metals - IndicesFutures Prices From Forexpros
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Uploads%20by% 20forum%20member s/Money%20making %20worksheets/ FUTURES.xlsm
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
digsupply <picsound@gmail.com >
- 3.2.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Thu Apr 12, 2012 7:18 pm (PDT)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Money making worksheets/EARNINGS.xlsm
Uploaded by : digsupply <picsound@gmail.com >
Description : Earnings From marketwatch in combination with RCHGetYahooQuotes - RCHGetYahooHistory - smfPricesBetween function
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Uploads%20by% 20forum%20member s/Money%20making %20worksheets/ EARNINGS. xlsm
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
digsupply <picsound@gmail.com >
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar