Messages In This Digest (4 Messages)
- 1a.
- Re: Recording each and every price stamp in a new row from a stream From: Randy Harmelink
- 1b.
- Re: Recording each and every price stamp in a new row from a stream From: Farhan Ansari
- 2a.
- Dates by using ADVFN info From: antonvanas1989
- 2b.
- Re: Dates by using ADVFN info From: Randy Harmelink
Messages
- 1a.
-
Re: Recording each and every price stamp in a new row from a stream
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Oct 4, 2011 8:10 am (PDT)
You'd need to write your own VBA timing routine to do the process.
But, seriously, if you need that kind of data, get a proper data service
provider.
On Tue, Oct 4, 2011 at 3:01 AM, Farhan Ansari <farhan86a@gmail.com > wrote:
>
> I had a query not related to the SMF Add-in (all praise to Randy and I
> apologize to the group to ask an off topic question). But does any body know
> how to record the data from a real-time steam. For e.g. the Google real-time
> display of a stock price can be imported to Excel and with the auto-refresh
> code the price can be made to appear updating on a real-time basis. However,
> can there be any code in excel to auto record each and every price stamp in
> a new row out of that stream?
>
>
- 1b.
-
Re: Recording each and every price stamp in a new row from a stream
Posted by: "Farhan Ansari" farhan86a@gmail.com farsdocs
Tue Oct 4, 2011 8:27 am (PDT)
Thanks Randy, so yes I am having the data service provider but the problem
is that I am only able to get the real-time data updated in a particular
cell. However, a silver lining for me "VBA timing routine" I will google
that out.
Thanks again!
On Tue, Oct 4, 2011 at 8:40 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> You'd need to write your own VBA timing routine to do the process.
>
> But, seriously, if you need that kind of data, get a proper data service
> provider.
>
>
> On Tue, Oct 4, 2011 at 3:01 AM, Farhan Ansari <farhan86a@gmail.com > wrote:
>
>>
>> I had a query not related to the SMF Add-in (all praise to Randy and I
>> apologize to the group to ask an off topic question). But does any body know
>> how to record the data from a real-time steam. For e.g. the Google real-time
>> display of a stock price can be imported to Excel and with the auto-refresh
>> code the price can be made to appear updating on a real-time basis. However,
>> can there be any code in excel to auto record each and every price stamp in
>> a new row out of that stream?
>>
>>
>
>
- 2a.
-
Dates by using ADVFN info
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Tue Oct 4, 2011 11:17 am (PDT)
Dear ,
I got my spreadsheet and use the information from advfn, now i would like to link dates automaticly to the date that advfn is giving.
at the first row the give a date like "2010/12" wich i grab the 2010 and would add it to ="01-01"&"-"& [the 2010 from adfvn] same i wanne do with ="31-12"&"-" & [the 2010 from adfvn] so i can get the year low and high with smf price between and the end price with smf price by date. but now my problem is that the end price with smfpricebydate work but the "01-01"&"-"& 2010 would not work, how can that be? do "" are the problem for the formula? or do you got another idea how i can get my dates linked with adfvn?
- 2b.
-
Re: Dates by using ADVFN info
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Oct 4, 2011 11:52 am (PDT)
How about some variation of:
=DATE(LEFT(C2,4),RIGHT( C2,2)+1,1) -1
=DATE(LEFT(C2,4),RIGHT( C2,2)-11, 1)
...where C2 contains the date string like "2010/12".
On Tue, Oct 4, 2011 at 11:17 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
>
> I got my spreadsheet and use the information from advfn, now i would like
> to link dates automaticly to the date that advfn is giving.
>
> at the first row the give a date like "2010/12" wich i grab the 2010 and
> would add it to ="01-01"&"-"& [the 2010 from adfvn] same i wanne do with
> ="31-12"&"-"& [the 2010 from adfvn] so i can get the year low and high with
> smf price between and the end price with smf price by date. but now my
> problem is that the end price with smfpricebydate work but the "01-01"&"-"&
> 2010 would not work, how can that be? do "" are the problem for the
> formula? or do you got another idea how i can get my dates linked with
> adfvn?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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