Multiple Live Feed / Data
Aug 28, 2009
I have set an excel spreadsheet set up to update live data from a URL every 5 minutes. However I am wanting to do try and save a bit of time if possible.
Basically I am monitoring horses bought on a game website. Each horse has the same URL except for the number at the end which goes up in 1 increments. The URL is already set up and when the horse is bought it changes from being blank to having the horses details etc.
At the minute I am able to autofill cells with each uinique URL using fill, then series menu. This is so I dont have to manually enter each URL, as hundreds may be bought each day so it would take too long to do this.
My question is this, am i able to have a automatic series linked to the 'data from web' function in data tab, instead of having to manually adjusting each URL for each individual horse.
View 9 Replies
ADVERTISEMENT
Mar 26, 2014
I new to excel and vba , and i have live stock feed data in excel.
The live feed has 17 rows..of ticker names and more column about values.live feed starts at 9.00 to 3.00
I want only 13th column data to save for every 5 min..in new spreedsheet.
I am also including a sample : live crude.xls
View 1 Replies
View Related
Jan 17, 2014
I am not good at excel. I would like to split buy and sell orders from the live feed and updating when new feeds come in.
LIVE FEED
BUY/SELLQTYPRICE BUY QTY PRICESELL QTY PRICE
B 4150
S 6200
S 4300 CHANGE TO
B 3350 B 4 150
B 2180 B 3 350 S 6 200
S 2220 B 2 180 S 4 300
B 1120 B 1 120 S 2 220
View 6 Replies
View Related
Sep 21, 2013
I thought about using it for forecasting purposes. I might try to use it together with live data (temperature, seasonal patterns)... but if I graph it, it starts from left to right...
How to modify the code a bit...
VB:
Shift:=xlUp, CopyOrigin:=xlFormatFromRightOrDown
I tried to change the code, but it did not worked.
View 8 Replies
View Related
Aug 26, 2006
a while back I posted Central Glossary to feed multiple documents to put a glossary at the end of a Word doc. Fabulous help and got it all sorted. Now I'm trying to do it at the end of an Excel w/b.
View 4 Replies
View Related
Dec 5, 2007
Running excel 2002, windows vista (some machines on network are running xp). I have a spreadsheet that I want to be able to edit from all computers on the network so that it shows real time changes on all PC's.
It would be like using google docs, I can't use google docs because my file size is 2.5MB and it is too much for it.
View 5 Replies
View Related
Jan 4, 2013
Is there any method in excel that can pay the way for drawing figures according to data feeded.
for Ex.
Say
Radius of circle=x
Now this x can be used for drawing the circle and the radius can be entered by user.
View 2 Replies
View Related
Jul 15, 2013
I have designed a live calendar and am trying to highlight selected dates from a column in the calendar. I am able to select single cell in the column and highlight the date in the calendar, But am unable to select multiple dates in the column and highlight multiple dates in the calendar using conditional formatting.
Eg: calender dates are from B5:H9 and multiple dates are in column J10:J13
J column
--------
J10 7/10/2013
J11 7/20/2013
j14 7/29/2013
View 4 Replies
View Related
Jan 26, 2012
I wanted to know how to download live data (stock data from a a website) through VBA.
View 1 Replies
View Related
Nov 30, 2008
I'd like to log live update data continuously,i.e. as the data in the cell changes. The problem I'm facing is that the data comes in at uneven intervals-- ranging from 30 to 50 ticks per second. So I can't really use a timer function. I need to use some function which saves the data as the cell value changes. So, for example, if cell A1 gets updated continuously, cell B1 could save the first value of A1 and then cell B2 could save the second value of cell A1-- and so forth.
View 9 Replies
View Related
Aug 19, 2013
I want to set up daily charts to monitor various things but Im not sure how best to set up the data in order to do this so it calculates automatically as data is refreshed.
I want to run daily activity data that tells me how many people attend each room per day. the aggregated data would include:
Number of attendances, by room (there are 11 rooms), by day
Each attendance grouped by category of patient (up to 25 categories)
Each attendance by type of attendance (various groups)
How should I set up the data to show these things in a way that it can be linked to a text file and refreshed daily on opening? the data at the moment is in rows per attendance rather than grouped in any way.
I would like the data to have dates and months etc automatically genetared by the attendance date in order to graph the above indicators, as well as a % atttendance in relation to capacity per room etc
simple excel template that I could try to manipulate my data into so I can get started. The data is generates using a transact SQL query and saved as a text file which I wabt to use for the daily stats.
View 6 Replies
View Related
Jun 19, 2009
eg having a live rate of intrest or exchange rate from the internet that is updated live whenever you load up excel and you are connceted to the intenet.
View 14 Replies
View Related
Dec 30, 2009
How To Connect Live Data in an Excel Sheet?
I want to track changes in some Stocks, I have made a sample file in Excel and would like to make it Live by Connecting it to a website..
However, I do not know how to go about the same?Can some please provide some examples as well as a File if possible explaining how it was done..
View 9 Replies
View Related
Oct 27, 2012
It is my general understanding that the change event system within Excel vba is fairly particular as to what will fit the mold of a qualifying change event.
For example, changes that the user imparts to the worksheet and other written code are legitament candidates for change events. However copying down data and cells changing their values indirectly rather than directly may not be considered in the Microsoft change event design.
I would like to know 2 things:
1) Does a cell updated by a market data feed mechanism qualify for a change event?
2) Any list of qualifying change event types. It seems that Microsoft does not have this information.
View 2 Replies
View Related
Jun 8, 2014
I need a forex excel spreadsheet that shows me the last 60 min of usd/jpy in real-time. It has to update every 60 minutes automatically.
View 1 Replies
View Related
May 7, 2009
Is there any way to have a web query stay connected and get live data from a site while still being able to use excel at the same time?
Basically the site has information that changes by the second and i need to keep a running record of it, and when it hits the variables needed i want to be able to trigger a set of code.
View 9 Replies
View Related
Mar 18, 2014
I would like to set up a maintenance register where I would have:
worksheet 1 - a page where staff can choose a location and choose a maintenance issue and hit submit
worksheet 2 - after they have hit submit the detail will appear in designated cells in worksheet 2 (a ledger of maintenance issues). so each submit should send the info to a new line in worksheet 2.
I have a basic knowledge of Excel and have used formulas and functions before but not VBA/Macros. Any step by step through setting up the submit button and macro correctly?
I've tried to do Worksheet("Register").Range("A2").Value = Worksheet("Request").Range("A1") after installing a push button but all I get is errors.
View 5 Replies
View Related
Oct 5, 2006
I have a program running on my computer called Orbits.
What Orbits does is monitor a race track, and via a transponder in each race car, when a race car crosses the start/finish line Orbits will record that infomation.
The orbits program continually feeds data out the port 50000.
I can start hyper-terminal (yes the free one that comes with windows) and create a link the the computer running orbits. I use IP and port (Ex. 10.0.0.1 and port 50000).
As the race is going on I can see the data in hyperterminal: Below is a sample.
$F,9999,"00:00:00","19:52:40","02:09:14","Green "
$F,9999,"00:00:00","19:52:41","02:09:15","Green "
$F,9999,"00:00:00","19:52:42","02:09:16","Green "
$F,9999,"00:00:00","19:52:43","02:09:17","Green "
What I would like to do Is to get this data LIVE into excel, as the race is going on.
I have no idea of to get this data into Excel since It is not saving it as a file.
View 9 Replies
View Related
Dec 2, 2012
Have a dde feed coming in from an external source. I also have a VBA written below to play sound whenever the feed goes below a certain level. When I key in values manually through the function bar the sounds play perfectly. But for some reason it is not reading the DDE feeds as value and it can go past my level without playing the sound.
Code:
Option Explicit
Private Declare Function sndPlaySound32 Lib "winmm.dll" _
Alias "sndPlaySoundA" (ByVal lpszSoundName _
As String, ByVal uFlags As Long) As Long
[Code]....
View 5 Replies
View Related
Oct 29, 2009
I have a cell $A$1 that contains a value, CLIENT or INTERNAL
I also have 2 named ranges, CLIENT or INTERNAL
I would like it (using Data Validation) so that the named range being selected for the list dropdown in cell $C$1 is the value of the cell CLIENT or INTERNAL cell $A$1. Tried indirect but not working with named ranges?
View 9 Replies
View Related
Dec 29, 2012
I want the following macro to be used as an excel addin, how to create addin and feed this macro on that particular addin so that its available each time I open a new workbook.
The macro is : [Code] ...........
View 2 Replies
View Related
Oct 17, 2013
I want to auto update ( refresh ) an external feed containing odds from Pinnacle Sports website, at 30-60 seconds intervals. Here is the link : [URL] .....
I would also want to apply some formulas to other columns in excel, but mainly I would want to know where is the change in odds. For example if Bayern Munchen has the odds 2, and after the refresh the odds dropped at 1.9 I would want to see the difference in another cell.
View 2 Replies
View Related
Dec 29, 2011
I've written this code:
=IF(((BP3="1")*AND(C3="Visit")),"The following code rule is being tested: "&D3&". This test is for the Family Practice specialty.","")
What I need to do is insert a carriage return/line feed right before the first & sign so that it is easier to read.
View 2 Replies
View Related
May 8, 2012
Call center stats: I have a SQL database which is LIVE. I would like to create a live report on excel from this database. (update my excel table automatically)
View 6 Replies
View Related
Aug 24, 2007
Each cell in Range("A1:A2000") contains a remark, each phrase or remark is
Between 5 & 70 characters all written without line feeds (carriage return,i mean Alt Enter) Just spaces between words. What I would like to do in every cell is to force a line feed (Alt Enter) every 10 characters, and if the 10th character happens to be in the middle of a word I want the line feed to be inserted at the end of this word. Note that the phrases are not necessarily multiples of 10.
View 2 Replies
View Related
Dec 14, 2011
I am using the following code to copy the contents of a DDE feed.
Code:
Private Sub Worksheet_Calculate()
Worksheets("Sheet2").Range("A1").EntireRow.Insert Shift:=xlDown
Worksheets("Sheet1").Range("A3:F3").Copy
Worksheets("Sheet2").Range("A1:F1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
What I want to do is only copy the row when the columns contain data, as it stands at the moment it's copying blank rows to sheet 2. Is there a way that I can do this?
View 3 Replies
View Related
May 30, 2008
I would like to use Excel as a measurement device. I have an inexpensive digital microscope that will store sequentially numbered pictures at the click of a button. I am then going to import the most recent picture into Excel and place a grid of transparent rectangles over the picture to serve as my ruler. Would it be possible to continuous update the Excel workbook with the output from the digital microscope?
View 7 Replies
View Related
Sep 11, 2007
If I write a multi-line text in a cell (then go down with alt+enter) and after copy the cell pasting on Notepad, it display before inverted commas and after textual content.
Instead, if I select directly the content from the formula bar, it isn't happen.
Do exist a way for copy and paste directly from the cell without select from the formula bar?
Maybe with a macro?
View 5 Replies
View Related
Jun 9, 2008
I have a cell (for example, "A1") which is inserted with a WINROS formula to retrieve some data into my spreadsheet. And it is running live at all time.
Actually, I can't think of any formulas to capture the value from cell "A1" to "B1". Because I do not want the value that I captured into cell "B1" running live. I just want the value "B1" fixed after captured.
View 9 Replies
View Related
Nov 26, 2008
I have two tables that pull data from two different SQL tables via an ODBC connection and refresh every 5 minutes. The table headers etc are all identical (it is support call information FYI) but what I want to do is display those tables as one as opposed to two seperate tables - can this be done relatively easily and hopefully without the use of VBA? (Unless anyone is willing to provide the code of course!!)
View 9 Replies
View Related