3 New Messages
Digest #2768
Messages
Tue Sep 10, 2013 2:22 pm (PDT) . Posted by:
luca.mantilero
You are right...
--- In smf_addin@yahoogrou
That one is not working either. Use the drop-down box to look at
earlier annual periods and you'll end up on the main page for the
company instead of seeing other annual periods.
On Tue, Sep 10, 2013 at 1:42 PM, <luca.mantilero@
For an example with
http://it.advfn.
e=company_data
<http://it.advfn.
de=company_data> it's working...
Tue Sep 10, 2013 8:28 pm (PDT) . Posted by:
"Deborah" dcharlotte99
Thanks so much, the GuruFocus 10-year spreadsheet looks like a good solution. It doesn't provide as much detail as AdvFN but I will make it work.
Tue Sep 10, 2013 11:11 pm (PDT) . Posted by:
"Douglas" jurisdoctor74
Randy,
I have been experiencing a problem (which I have been unable resolve) using your smfPricesByDates function and would greatly appreciate your assistance in finding a solution.
When I use smfPricesByDates for retrieving historical prices from Yahoo!, it successfully downloads the data but I seem unable to perform any arithmetical operations on that data because they appear to be non-numeric. If I attempt to perform some mathematical operation on a downloaded stock price, I receive a "Run-time '13' Type mismatch" error.
However, if I first save the stock price from VBA to a spreadsheet cell and then recall it from that cell back into VBA, it appears to become transformed into numeric data which I can then use in a formula without receiving an error message.
However, if I merely download a current stock price using element #25, the data appears to be numeric and can immediately be arithmetically manipulated.
This simple program will demonstrate these observations:
Sub Test()
SP = smfPricesByDates("AA", "9/9/2013";)
'SP = RchGetElementNumber("AA", 25)
If IsNumeric(SP) Then
Range("C10") = SP
Else: Range("C10") = "Non Numeric"
End If
Range("C12") = SP
SP = Range("C12")
Range("C12") = SP * 2
End Sub
I would like the data retrieved by smfPricesbyDates to be numeric and usable in a formula. I cannot figure out what's going here and would appreciate your assistance. (I am using MS Office Excel 2003 with MS XP Professional Service Pack 3.)
Thanks for your help and thanks for creating this fantastic program.
Doug
I have been experiencing a problem (which I have been unable resolve) using your smfPricesByDates function and would greatly appreciate your assistance in finding a solution.
When I use smfPricesByDates for retrieving historical prices from Yahoo!, it successfully downloads the data but I seem unable to perform any arithmetical operations on that data because they appear to be non-numeric. If I attempt to perform some mathematical operation on a downloaded stock price, I receive a "Run-time '13' Type mismatch" error.
However, if I first save the stock price from VBA to a spreadsheet cell and then recall it from that cell back into VBA, it appears to become transformed into numeric data which I can then use in a formula without receiving an error message.
However, if I merely download a current stock price using element #25, the data appears to be numeric and can immediately be arithmetically manipulated.
This simple program will demonstrate these observations:
Sub Test()
SP = smfPricesByDates(
'SP = RchGetElementNumber
If IsNumeric(SP) Then
Range("
Else: Range("
End If
Range("
SP = Range("
Range("
End Sub
I would like the data retrieved by smfPricesbyDates to be numeric and usable in a formula. I cannot figure out what's going here and would appreciate your assistance. (I am using MS Office Excel 2003 with MS XP Professional Service Pack 3.)
Thanks for your help and thanks for creating this fantastic program.
Doug
Tidak ada komentar:
Posting Komentar