Drawing Figure According To Data Feed

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


ADVERTISEMENT

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 View Related

Save Live Feed Data To Another Sheet Every 5 Min

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

Highlight Cell And It Takes The Figure Within In Away From Another Figure?

Feb 18, 2013

I've got a spreadsheet with several rows and the numbers within those rows are totalled up at the bottom. Is there a way where i can highlight the cell within the spreadsheet and it takes it off the accumulative total at the bottom? or something similar to this effect? I just don't want to have to remove figures from this spreadsheet and highlighting will be a good way of seeing what has been done

View 1 Replies View Related

Setting Up Excel Data In Aggregated Way That Can Feed Dashboard Or Daily Report

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

Does Cell Updated By Market Data Feed Mechanism Qualify For Change Event

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

Drawing A Blank On How To Sum Cells With Like Data

Feb 5, 2010

I have a worksheet with 27,000+ rows. Item numbers are listed in column J and quantities in column E. The rest of the data on the sheet is not needed. An item number may be listed multiple times. I'm trying to create a new sheet that lists each item number once with the sum of all the quantities associated with that number. The data is sorted so all "like" item numbers are listed in consecutive rows.

View 5 Replies View Related

Combine Text & Figure When The Figure Is In -ve?

Oct 14, 2009

I learnt that " " & can combine the text and figure. However, when it comes to a negative numbers, i dont know how to maneouver it. Eg, Cell A1 is USD(50,000.00) and the comment in Cell B1 is Cost is USD(50,000.00). So the function in B1 = "Cost is "& what to put here?

View 3 Replies View Related

Worksheets Drawing Data From Target Cells Without Moving If Add Lines?

Feb 19, 2014

I have one excel file sheet in which we enter client data and another page in the same file that formats the data. Each new row is another client.

It is a simple formula in the data formatting sheet ='data sheet'A23 for example.

The problem is when we add client data above A23, say 2 rows, the format data page will follow the original cell and now say ='data sheet'A25.

How do I keep the cell as ='data sheet'A23 no matter what I do the original page?

View 1 Replies View Related

Return Latest Reported Figure By Firm In Panel Data

Apr 16, 2013

I have data for various firms - such as revenues, employees, etc. - for multiple time periods. There is no uniformity, so for some firms I'll have data for 8 time periods, for others for 1, for others for 30, etc. I have hundreds of columns, but the three relevant ones are: in one column is firm ID, in another column in reporting date, and in another column is number of employees.

The attached sample data will make it easier to understand.

I'd like a summary table that tells me the most recent reported number of employees for each firm, and the date of that reported figure. If that firm never reported any employee figures, then the summary table should still have a row for that firm ID, but blanks in the 'reporting date' and 'employees' columns. So, the summary table should be 3 columns - firm ID, reporting date and employees.

The challenging aspect is that the most recent reported employee figure is not always the most recent date on which we got data from the firm (so I can't just do a sort followed by a 'remove duplicates'). It'll need either a multi-step formula solution or a VBA code (that's my guess).

The attached sample data will make it easier to understand. It has the form of data I have and the desired output form.

Excel help needed.xlsx‎

View 3 Replies View Related

Nested Data Validation: Figure A To Enforce Dual Data Validation On A Single Cell?

Aug 19, 2009

I'm trying to figure a to enforce dual data validation on a single cell. That is, I need to restrict the user to entering only a decimal value, only if a particular other cell (say A2) is blank. To put it another way, if A2 is blank, the user can enter a decimal value, but if A2 is not blank, the user cannot enter anything. I can use Data Validation to enforce either the decimal restriction or the ISBLANK, but I'm not sure how to make them work together.

View 2 Replies View Related

Identifying Data In One Column Based On Highest Figure Data In Another Column?

Jun 19, 2014

I am trying to write a formula that shows the best grade for each each student and the subject in which
that grade was achieved.

In a previous post i was shown how to identify the highest grade

MAX(IF(A$3:A$34=A7,C$3:C$34))

I hit CTRL, SHIFT & ENTER to activate the formula - Result in column E

However, I also want to identify the subject in which they scored their highest grade in column F

I have two problems

1. I don't know how to write a formula that brings in the subject based on the grade for each student

2. I don't know how to write a formula in case there is a tie (see DAVID L)

View 11 Replies View Related

VBA Does Not Read DDE Feed Values

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

Using Selection To Feed List

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

How To Create Addin And Feed Macro

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

Split Buy And Sell From Live Feed

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

Auto Update External Feed

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

Inserting Carriage Return And Line Feed?

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

Dynamic Feed Excel Table From SQL Database?

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

Central Glossary: Feed Multiple Documents

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

Insert Line Feed At Intervals In A Phrase

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

VBA - Macro Run When System Clock Changes - Forecasting With Live Feed?

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

Code To Copy Contents Of DDE Feed - Modify Worksheet

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

Measurements Of Feed Of Numbered Pictures From Digital Microscope

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

Replace Line Feed With Carriage Return In Text File

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

Cant See Drawing Toolbar

May 22, 2007

I've recently got a new computer and this problem is driving me nuts.
When I click view!toolbars!drawing, nothing happens. No drawing toolbar appears at the bottom of the screen where it used to be. There's a small "drawing toolbar" icon on the main toolbar, but whether this is depressed or not makes no difference either.

I understand this may be changed in the 2007 version, but Im using Excel 2000

View 10 Replies View Related

Drawing Grid

Nov 26, 2007

I want to have 2 cells where I can enter 2 numbers (length & height) so that a grid can be plotted. For example, a big sheet of paper size is length 30" x height 8", if first number is 10" (length) is entered, it will plot 3 lines across 30" (cos 30" divided by 10" equals to 3) and if I enter 2" (height) on 8", it will then cut it into 4". Attached a file for better understanding.

View 14 Replies View Related

Corresponding Value Drawing According To Rule

Oct 29, 2013

In my attached sheet I've to find out final result in Column "F" (green shaded). My boss many times a year increases salary by certain percentage (say 30% or 40%) which is given in "E" column. After that I need to adjust it according to Pay Scale given in right side. For example one Executive's salary reaches 19880 after % increase. Now in pay scale we see in executive (row no. 13) it crosses 19800 so his final salary should be next upper value i.e 20600 (if it reached to 20700 after % increase, then his final salary could be 21400). That is final salary should be multiple of designation's increment plus minimum gross salary (Here 800X10=8000+11800=19800, since it exceed by 800, so salary should be 800X11=8800+11800=20600)

So we can either pull data from right side table or we can give formula in "F" column to get the required result.

salary adjustment.xlsx‎

View 7 Replies View Related

VBA Drawing Objects

Jul 15, 2008

I want to use VBA to update a drawing object's color, such as a circle.

For example, pretend I am counting sheep and I need to know when I have reached the maximum count by the visual aide of a stoplight. The script in my head reads: If the max. count of the sheep is less than 5, then the stoplight is green. If the max. count of the sheep is equal to 5, then the stoplight is yellow. If the max. count of the sheep is greater than 5, then the stoplight is red.

Is there a way to do such a thing on excel and with VBA?

View 9 Replies View Related

Drawing A Line With VBA

Jun 22, 2009

How would i have VBA draw a line between a two ranges? say i have a named range of "start" and another name range "stop". i want to draw a red line between them. how can i do that with code. this is beggining my education for a much larger project I want to do later in the future.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved