|
PureBytes Links
Trading Reference Links
|
Mike,
Since you have had PCQuote you know they have a $75/mo subscritpion rate. With
this package you get the Excel support. So with the Excel I will chart the
candlesticks on the stock as well as the PSE. I also look at the UP/Down Volume
ratio for NYSE & NASDAQ. If the volume ratio greater than 2 the market is
pretty bullish. IF it is between 1 and 2 the market isn't sure. If it is less
than one, the market is bearish.
We will be plotting tick as well soon.
Ok back to Excel. And this is the important part. The data that comes into
Excel can get lost along the way or may not update automatically in the quote
table. The quote arrays are ok. SO this is what you do. You have a macro update
the link to the PCQuote servers for you every couple of seconds. You can do
this automatically. When/if you get to that point I'll send you the macro if
you want it.
Now I have two other computers that I have networked, peer to peer, with Win95.
So what I will do is have one spreadsheet that brings in the data from PC Quote
via the internet. I then copy that data to another spread sheet and paste the
LINK. (Important.)
Then in this second spread sheet I have the charts. I then close the second
spread sheet and open it up across the network on the other computer. I then
have a macro update the links from the other computer automatically. With a 486
it is pretty close to real time.
So the computer connected to the internet getting quotes acts like a local
server in my LAN. Pushing the data to other computers. I do this on both
computers. So in review. I take one spreadsheet and get may data for the
markets/index in a quote table format. It will link to a second spreadsheet on
the 2nd computer. I will have a third spreadsheet that gets data for securities
in quote table format which will then link to a 4th spreadsheet on the third
computer. Spreadsheets 1&3 get the data from PCQuote. Spreadsheets 2&4 link to
1&3 from the other computers and have charts.
Now to MS 6.0. You can take the Close and OLE it from Excel to MS 6.0. Take the
column down to your last #N/A and copy/past the link to MS6.0 (In an empty
window). If you save it as a smart chart the link will stay for good. In this
case I have MS 6.0 on the same computer as the Excel spreadsheet it is linked
to. SO it doesn't matter if it is on the server or over on one of the peers.
Also when Excel updates the link, MS6.0 updates live.
In addition the #N/As don't show up on the chart in MS6.0. So that is nice.
What you see in MS6.0 is something like this. Think of a blank yard stick with
no numbers on it. That will represent the length of a column that we linked
from Excel to MS6.0. The top of the yard stick will be the beginning of the day
and the end of the yard stick will be at the end of the day. As the data
gradually fills the column then there will be numbers on the yard stick. The
blank yard stick is also like the MS6.0 window where you paste the link. You
will have some data to the left and white space to the right as the data comes
in it fills in the white space on the right up.
As far as linking Open,high low close for a time period from Excel to MS6.0, I
don't know about that.
Also one should be able to DDE accross the network in Excel but we have not
gotten there yet. It is suppose be a bit faster than what we currently have.
I hope this helps.
Harley Meyer
On Tue, 8 Jul 1997 17:15:54 -0500,
Michael L. Robb wrote...
>Harley:
>
>Are you talking about using PC Quote for live real time quotes into MS, or
>MS/RT?
>
>I didn't know we could do that. I thought we had to take the live quotes
>only via the PC Quote charting software; which is slow and cumbersome. I
>cancelled it twice already.
>
>Would you kindly explain how to combine PC Quotae (www) with MS/RT?
>
>I would certainly prfer todisconnect my Signal, and ask for some money back
>for all the information thaey are not sending me; and/or on time.
>
>Regards,
>
>Mike
>
>P.S. I Think you mentioned this to me before, but I couldn't see the
>connection; because of terrible experience with PC Quote in the past.
>
>
>
>At 11:11 PM 7/7/97, you wrote:
>>It is a bit late so I will go into further detail tomorrow but your wsting
>your
>>money with Signal.
>>
>>You will be better off going to PCQuote through the internet. They're faster.
>>You can do charting in Excel. Also with a little hufspa, you can take your
>data
>>pump it across a lan and chart on several computers at the same time.
>>
>>Also if you want to plot in MS 6.0 you can also OLE the data feed in and get
a
>>live plot of the close.
>>Anyway they have a free 7 day trial that will let you compare how you are
>>getting screwed by Signal. A buddy of mine had been on Signal for a couple of
>>years and will be switching to PCQuote. He just signed on the dottd line and
>>Signal has received his notice to quit. Which ends at the end of the week.
>>
>>The risk taker that I am, I am hoping for and banking on the new release of
MS
>>RT to be flexible enough that I can use a RT data provider like PCQuote.
>>
>>Anyway I guess I told all.
>>
>>Harley
>>On Mon, 07 Jul 1997 19:52:00 -0400,
>>billblue@xxxxxxxxxxx wrote...
>>>I have been forced to return to work in Boston. I am considering
>>>replacing my Signal Box with a Signal Card for a laptop. It seems to me
>>>that, since the current MetaStock RT is a DOS program, the laptop will
>>>not be able to multitask and will thus be a dedicated machine. For this
>>>reason I think that a barebones machine is all that I need to run
>>>MetaStock RT. Does anyone have any suggestions for laptop specifications
>>>for this application. Also wondering if anyone has any comments about
>>>the Signal Card.
>>>Thanks, Bill Blue
>>>
>>>
>>
>>Harley Meyer
>>meyer093@xxxxxxxxxx
>>
>>
>>
>>
>
>
Harley Meyer
meyer093@xxxxxxxxxx
|